Join problem

luckiejacky

我想join log table to order table, but some logs have no order id
since they are plain service.
In this picture, the 3 logcode are different, but they have the same value
They should be 1000,10000,1000
but they all 10000
Why?

zenchiu

order id又show唔哂,只係睇你堆CODE當我地神人???
你係left join, 有冇想過變左one to many....

杜龍

order id又show唔哂,只係睇你堆CODE當我地神人???
你係left join, 有冇想過變左one to many.... ...
zenchiu 發表於 2013-11-5 11:26

    nono....100蚊一個answer...
有意PM

tuyylihk

你真係當你問緊你面前既電腦咩...
連你個TABLE個結構係點都唔知真係答條毛
同埋唔該SHOW CODE都SHOW TEXT唔好SHOW圖好唔好,想睇死人咩

SHOW文字先啦,好難睇...
我只能懷疑你係咪JOIN錯TABLE

henrywho

至少 post 條 文字版 SQL 上嚟吖 ....