Member Avatar for vedro-compota

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)

  • 2 Contributors
  • 1 Reply
  • 215 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by simplypixie
Member Avatar for simplypixie

You query is not formatted correctley

select  NAME from TAB1 left join TAB2 on  TAB1.ID = TAB2.ID where TAB1.NUMBER= TAB2.NUMBER;

Or if you are trying to join with a 3rd table

select  NAME from TAB1 left join TAB2 on  TAB1.ID = TAB2.ID LEFT JOIN TAB3 ON TAB3.NUMBER=TAB2.NUMBER where Put Your Where Clause Here;
commented: ++++++++++ +3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.