|
Hm, add another LEFT JOIN?
SELECT UI.girl as girl,SB.clicks as surferclicks,V.clicks as voteclicks FROM update_info as UI
LEFT JOIN surfer_behavior as SB on UI.girl = SB.girl
LEFT JOIN votes as V on V.girl = SB.girl;
.. something like that maybe?
edited for typo. Hm, maybe the "as" things just confused...
SELECT update_info.girl as girl,surfer_behavior.clicks as surferclicks,votes.clicks as voteclicks FROM update_info
LEFT JOIN surfer_behavior on update_info.girl = surfer_behavior.girl
LEFT JOIN votes on votes.girl = surfer_behavior.girl;
|