作者: luckiejacky 時間: 2013-11-2 08:46 標題: 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?
[attach]1600489[/attach]
作者: zenchiu 時間: 2013-11-5 11:26
order id又show唔哂,只係睇你堆CODE當我地神人???
你係left join, 有冇想過變左one to many....
作者: 杜龍 時間: 2013-11-5 11:37
order id又show唔哂,只係睇你堆CODE當我地神人???
你係left join, 有冇想過變左one to many.... ...
zenchiu 發表於 2013-11-5 11:26
nono....100蚊一個answer...
有意PM
作者: tuyylihk 時間: 2013-11-5 11:41
你真係當你問緊你面前既電腦咩...
連你個TABLE個結構係點都唔知真係答條毛
同埋唔該SHOW CODE都SHOW TEXT唔好SHOW圖好唔好,想睇死人咩
SHOW文字先啦,好難睇...
我只能懷疑你係咪JOIN錯TABLE
作者: henrywho 時間: 2013-11-5 11:53
本帖最後由 henrywho 於 2013-11-5 15:27 編輯
至少 post 條 文字版 SQL 上嚟吖 ....
