hi mysql athlets!))
Guys, please tell me - how to solve problem like this =
I have sql-query like this one (imagine that all this tables and fileds exists - and error can't be in its adsence) =
select NAME from (TAB1 left join TAB2 on TAB1.ID = TAB2.ID) as NEWTAB where NEWTAB.NUMBER= TAB3.NAMBER;
there is some unidentified for me problem in as
NEWTAB
- is this syntax impossible in MySQL - if so - what could be use instead ?
big thanks in advance)