DB
MYSQL OUTER JOIN
ndlessrain
2012. 7. 29. 20:53
728x90
from nstresult n
LEFT OUTER JOIN tourplayer b ON n.to_cd=b.to_cd AND n.entrant_team_cd_l=b.id_no
LEFT OUTER JOIN tourplayer c ON n.to_cd=c.to_cd AND n.entrant_team_cd_r=c.id_no
728x90