Le Official Penang tered V124 (Wan to Dai), Unofficial supporter of Dayumm burger Group
|
|
 Oct 22 2013, 09:38 AM
Return to original view | Post
#161
|
 
Senior Member
1,202 posts Joined: May 2007 From: Penang  
|
QUOTE(Ah WanG @ Oct 22 2013, 09:31 AM) 29 jan i kena makan reunion liao.. my family early 1 day for relatives side to join eh lol aiyo.. nvm la.. ayam will has be back until 9 feb so still ken go makan makan summon myky44 to kambing penang makan then go yeng keng shots lulz |
|
|
Oct 22 2013, 09:49 AM
Return to original view | Post
#162
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(Ah WanG @ Oct 22 2013, 09:42 AM) he kena apply permit dulu hahahawhen you back from coollim? QUOTE(MyKy44 @ Oct 22 2013, 09:44 AM) lol when. CNY ah? ada kapal terbangggggggg yooooooooooi'll need drive to south then drive up north then drive back to klang? lol sounds penat /yaoming when you go back north? |
|
|
Oct 22 2013, 09:56 AM
Return to original view | Post
#163
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(MyKy44 @ Oct 22 2013, 09:55 AM) for pg marathon lor mana gua tau eh wat date is it again ah?  and jew always kambing sinjiapor no tiem meet up  |
|
|
Oct 22 2013, 02:15 PM
Return to original view | Post
#164
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(xiaojie @ Oct 22 2013, 02:12 PM)  so fast talk abt cny d a  |
|
|
Oct 22 2013, 03:00 PM
Return to original view | Post
#165
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(don^don @ Oct 22 2013, 02:41 PM) kanneh, last month i update invdtl table but i kepo go set date range >01/10/2013, no wonder figure drop by few mil help me fix this join part  old invoice with aging >3 months all not in commission report, sales agents all kpkb need to join cpvhdr and cost table  CODE select job.biztype,ivjob.awbbl,ivjob.mawbno,ivhdr.docdate,ivhdr.docno,job.custname,job.podctry,job.destcity,job.jobdate,job.polctry, job.oagent,revenue.amtfc,revenue.actualcurrcode,revenue.amtlc,job.totpcs,job.totpcs_ut,job.totcwgt,job.totvol, job.totvol_ut,revenue.actualexrate,revenue.chrgcode,revenue.chrgdesc,revenue.vatamtlc,ivhdr.isfullcn, cpvhdr.payeename,cost.chrgdesc from job inner join revenue on job.unid=revenue.job_unid left join ivjob on ivjob.job_unid=job.unid right join cpvhdr on cpvhdr.cpvhdr_unid=cpvhdr.unid inner join ivhdr on ivjob.ivhdr_unid=ivhdr.unid and ivhdr.voidby is null |
|
|
Oct 22 2013, 03:07 PM
Return to original view | Post
#166
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(crazy25kid @ Oct 22 2013, 03:04 PM) inner join ivhdr on ivjob.ivhdr_unid=ivhdr.unid and ivhdr.voidby is null relationship is i need to join 6 tables - cost, ivhdr, revenue, cpvhdr, job and ivjobini bukan part of join condition...sila put in where section other than that...i tak tau wth is the relationship. so tak tau i use simple query to select the stuff i want then it auto join for me. but nao after i add in cpvhdr and cost table it show runtime error liao i dunno what wrong also |
|
|
Oct 22 2013, 03:17 PM
Return to original view | Post
#167
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(crazy25kid @ Oct 22 2013, 03:12 PM) join cpvhdr on cpvhdr.cpvhdr_unid=cpvhdr.unid ayam konpiused. just need teh UNID from cpvhdr at the from section.. like that is wrong? lu join apa table...refer back same table eh...sure error la so should be inner join cpvhdr on cpvhdr.job_unid=job.unid? |
|
|
Oct 22 2013, 03:30 PM
Return to original view | Post
#168
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(Ah WanG @ Oct 22 2013, 03:26 PM) cpvhdr cash payment voucher header la cpcpcpcp cp video hd recording?  |
|
|
Oct 22 2013, 03:44 PM
Return to original view | Post
#169
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(crazy25kid @ Oct 22 2013, 03:31 PM) u draw out ur relationship...u will notice that your cpvhdr is stand alone wokay i kinda understand what you mean.so confirm error eh let me draw for u job inner join revenue on job.unid=revenue.job_unid job -> revenue left join ivjob on ivjob.job_unid=job.unid job -> revenue -> ivjob right join cpvhdr on cpvhdr.cpvhdr_unid=cpvhdr.unid job -> revenue -> ivjob ??? cpvhdr inner join ivhdr on ivjob.ivhdr_unid=ivhdr.unid job -> revenue -> ivjob -> ivhdr ??? cpvhdr inner join cpvhdr on cpvhdr.job_unid=job.unid should do it right?  |
|
|
Oct 22 2013, 04:25 PM
Return to original view | Post
#170
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(crazy25kid @ Oct 22 2013, 03:50 PM) tak tau what kind of join u need... cpvhdr does not have column job_unid, like ivhdr , i need to join thru cpvjob tablebut basically, u cannot join 2 column of the same table in the ON statement job <> cpvjob <> cpvhdr so ini maciam how to do liao.. i konpiused myself dunno what do jor |
|
|
Oct 22 2013, 04:41 PM
Return to original view | Post
#171
|
|
Senior Member
1,202 posts Joined: May 2007 From: Penang
|
QUOTE(don^don @ Oct 22 2013, 04:33 PM) cost.chrgdesc <- anak nikah? yeah lol.. still dunno how to join the additional 3 tables together into existing query QUOTE(crazy25kid @ Oct 22 2013, 04:36 PM) ur table le...i duno 1 lo i refer data dictionary liao still dunno how to join sila refer data dictionary if need another table to link...then u ma link in the other table lo but u link until grandfather mother also inside...good luck with your select all i know as of now is need link via job -> cpvjob -> cpvhdr to return the query and cost already has job_unid field so nonit extra link my select already selected the needed fields liao  |
| Bump Topic Topic ClosedOptions New Topic |
| Change to: |  0.0348sec
 0.17
 6 queries
 GZIP Disabled
Time is now: 8th December 2025 - 02:31 AM |
Quote