left join alias mysql

Primary tabs

vedro-compota's picture
Submitted by vedro-compota on Sun, 12/25/2011 - 21:28

Comments

vedro-compota's picture

vedro-compota

Sun, 12/25/2011 - 22:01

select NAME from (TAB1 left join TAB2 on TAB1.ID = TAB2.ID) from NEWTAB where NEWTAB.NUMBER= TAB3.NAMBER;

_____________
матфак вгу и остальная классика =)