lembu bila ada?

Local or VN?

Now heading to Ipoh Salted Jiken!!

very unlikely ~ no demand

Local la ~ VN no supplies

Thinking wan dayummm

Apa ni

wah busy busy
sakit kepala everyday

bila mao minum

We can consider go teahouse also if you all wan

sorry leji, abit bz, the problem solved? yim zai mcm sudah solved your problem

juznow super funny case, accountant called ask how to settle unbalance bank recon. i ask her why unbalance, she say bank side double enter Rm360, i ask her just statement letter or your bank account also double entry, she say she dunno, i ask her bank no call u meh? give u free Rm360 oh, they no realize meh? so good ka this bank, she diam diam, say dunno nia. ngaiti... then kept on pestering me how to solve the bank recon unbalance... walao eh... want me wipe her ass gilat gilat.

cpvhdr does not have column job_unid, like ivhdr , i need to join thru cpvjob table
job <> cpvjob <> cpvhdr

so ini maciam how to do liao.. i konpiused myself dunno what do jor

cost.chrgdesc <- anak nikah?

ur table le...i duno 1 lo
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

job = revenue (job.unid=revenue.job_unid)
job = ivjob (ivjob.job_unid=job.unid)
cpvhdr = cpvhdr (cpvhdr.cpvhdr_unid=cpvhdr.unid) <- why same table join ownself?
ivjob = ivhdr (ivjob.ivhdr_unid=ivhdr.unid)


job.biztype
job.custname,
job.podctry,
job.destcity,
job.jobdate,
job.polctry,
job.oagent,
job.custname,
job.podctry,
job.destcity,
job.jobdate,
job.polctry,
job.oagent,
job.totpcs,
job.totpcs_ut,
job.totcwgt,
job.totvol,
job.totvol_ut,

ivjob.awbbl
ivjob.mawbno,

ivhdr.docdate,
ivhdr.docno,
ivhdr.isfullcn,

revenue.amtfc,
revenue.actualcurrcode,
revenue.amtlc,
revenue.actualexrate,
revenue.chrgcode,
revenue.chrgdesc,
revenue.vatamtlc,

cpvhdr.payeename,

cost.chrgdesc

yeah lol.. still dunno how to join the additional 3 tables together into existing query

i refer data dictionary liao still dunno how to join

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

this week shld be no go island lioa

select * from

job on

job.unid = revenue.job_unid

LEFT OUTER JOIN

ivjob.job_unid=job.unid

LEFT OUTER JOIN

ivjob.ivhdr_unid=ivhdr.unid

LEFT OUTER JOIN

cpvjob.XXXX=job.XXXX

LEFT OUTER JOIN

cpvjob.cpvhdr_unid=cpvhdr.unit

where ivhdr.voidby is null

The feeling of sweating after fever is good. Comfortable.

alo ~

ghoss, you banyak early today

Good morning Penang kia

today early cos need to prepare for tonight

Wow, I still have lotsa to learn from you, Master Shifu

Sleepy betul, I got homework must do abo will kena scold