Le Official Penang tered V124 (Wan to Dai), Unofficial supporter of Dayumm burger Group
|
|
 Oct 11 2013, 04:32 PM
Return to original view | Post
#41
|
 
Senior Member
1,424 posts Joined: Jan 2003 
|
QUOTE(ahchun @ Oct 11 2013, 04:14 PM) of course dont have la menteri can get the increment and do less bapak also no allow u do that unless mentri kerajaan malaysia   This post has been edited by crazy25kid: Oct 11 2013, 04:32 PM |
|
|
Oct 11 2013, 05:45 PM
Return to original view | Post
#42
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
duno is curse or wat...how come i alwiz last day si pek bo eng 1 !!!
|
|
|
Oct 17 2013, 04:27 PM
Return to original view | Post
#43
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
ai kun in new company...how le?
|
|
|
Oct 17 2013, 04:43 PM
Return to original view | Post
#44
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(xiaojie @ Oct 17 2013, 04:29 PM) too free a? very sleepyhow's the new environment? first week memang nothing do 1 ma feel like back in hell env...IT services  QUOTE(ahchun @ Oct 17 2013, 04:32 PM) ada amoi cantik ? ada...still thinking when will meet celeb |
|
|
Oct 18 2013, 08:37 AM
Return to original view | Post
#45
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(ahchun @ Oct 17 2013, 06:35 PM) wow macam nice place to work ni first week...env not bad |
|
|
Oct 18 2013, 09:15 AM
Return to original view | Post
#46
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
u all really believe in cool stories eh?
|
|
|
Oct 18 2013, 11:38 AM
Return to original view | Post
#47
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(harrychoo @ Oct 18 2013, 11:27 AM) rejected the offer, seems like they really want to come back with better offer dilemma of being appreciated.  dilemma now |
|
|
Oct 18 2013, 11:45 AM
Return to original view | Post
#48
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(harrychoo @ Oct 18 2013, 11:39 AM) long time no jump liao..sure got some reluctance 1 haha..comfort zone establishedif u ada plan for sg...i recommend faster also before u grow roots. |
|
|
Oct 21 2013, 03:00 PM
Return to original view | Post
#49
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(roystevenung @ Oct 21 2013, 02:58 PM)  2G apa meaning? Also, if both sim card got incoming calls also you cant answer lar, me still no brain why need 2 sim?work and personal number wife and mistress number...etc |
|
|
Oct 22 2013, 03:04 PM
Return to original view | Post
#50
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(reijikageyama @ Oct 22 2013, 03:00 PM) help me fix this join part inner join ivhdr on ivjob.ivhdr_unid=ivhdr.unid and ivhdr.voidby is nullneed 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 ini bukan part of join condition...sila put in where section other than that...i tak tau wth is the relationship. so tak tau |
|
|
Oct 22 2013, 03:12 PM
Return to original view | Post
#51
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(reijikageyama @ Oct 22 2013, 03:07 PM) relationship is i need to join 6 tables - cost, ivhdr, revenue, cpvhdr, job and ivjob join cpvhdr on cpvhdr.cpvhdr_unid=cpvhdr.unidi 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 lu join apa table...refer back same table eh...sure error la |
|
|
Oct 22 2013, 03:31 PM
Return to original view | Post
#52
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(reijikageyama @ Oct 22 2013, 03:17 PM) ayam konpiused. just need teh UNID from cpvhdr at the from section.. like that is wrong? u draw out ur relationship...u will notice that your cpvhdr is stand alone so should be inner join cpvhdr on cpvhdr.job_unid=job.unid? 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 |
|
|
Oct 22 2013, 03:50 PM
Return to original view | Post
#53
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(reijikageyama @ Oct 22 2013, 03:44 PM) wokay i kinda understand what you mean. tak tau what kind of join u need...inner join cpvhdr on cpvhdr.job_unid=job.unid should do it right?  but basically, u cannot join 2 column of the same table in the ON statement |
|
|
Oct 22 2013, 04:36 PM
Return to original view | Post
#54
|
|
Senior Member
1,424 posts Joined: Jan 2003
|
QUOTE(reijikageyama @ Oct 22 2013, 04:25 PM) cpvhdr does not have column job_unid, like ivhdr , i need to join thru cpvjob table ur table le...i duno 1 lojob <> cpvjob <> cpvhdr so ini maciam how to do liao.. i konpiused myself dunno what do jor 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 |
| Bump Topic Topic ClosedOptions New Topic |
| Change to: |  0.0431sec
 0.59
 6 queries
 GZIP Disabled
Time is now: 10th December 2025 - 12:44 PM |
Quote