Join problem

我想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?
附件: 您需要登錄才可以下載或查看附件。沒有帳號?註冊

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

TOP

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



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

TOP

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

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

TOP

本帖最後由 henrywho 於 2013-11-5 15:27 編輯

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

TOP