SQL Error says every derived table must have alias

Question

When I use this query

select s.* from ta as s left join (select a.* from tb as a)

This error appears

every derived table must have its own alias

fully address answer @Sebastien – Ra'fat Haj Ali May 03 '15 at 08:49 — Ra'fat Haj Ali, May 03 '15 at 08:49

Robert · Accepted Answer · 2015-04-28T12:14:57.753

0

You need to add an alias after parenthesis as below

select s.* 
from ta as s 
left join (select a.* from tb as a) as a on/* here you need input condtion */

edited Apr 28 '15 at 12:14

answered Apr 28 '15 at 11:50

Robert

c , What Mean ? @Parado – Ra'fat Haj Ali Apr 28 '15 at 11:55
@RafatHajAli Where is c? – Robert Apr 28 '15 at 11:58
I have an error in SQL syntax – Ra'fat Haj Ali Apr 28 '15 at 11:59
@RafatHajAli I don't have `c` in my query :) – Robert Apr 28 '15 at 12:00
Ok c disappear but now i have an error in sql syntax , what is that error – Ra'fat Haj Ali Apr 28 '15 at 12:03
@RafatHajAli Can you show me that error? Try to run my query again - I added `as` before `a`, maybe this will solve the problem – Robert Apr 28 '15 at 12:05
No , Error Still Apperar You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 – Ra'fat Haj Ali Apr 28 '15 at 12:07
@Parado: Error must be `"join condition missing"` – Ravinder Reddy Apr 28 '15 at 12:13
need ON s.someting=s.something – StanislavL Apr 28 '15 at 12:14
@Ravinder I though that but I think it's not complete OP's query – Robert Apr 28 '15 at 12:15
@RafatHajAli Is it your full query? – Robert Apr 28 '15 at 12:15
Yes , Success Thank You @Parado – Ra'fat Haj Ali Apr 28 '15 at 12:16
@RafatHajAli I'm glad I could help you. – Robert Apr 28 '15 at 12:17
Thanks For Help @Parado – Ra'fat Haj Ali Apr 28 '15 at 13:02

1 Answers1