MYSQL : an error in your SQL syntax

Question

select t.name 
from (pratip_Person natural join pratip_M_Director) as t;

What is the syntax error in this query?

I googled a lot but could not come to a satisfiable solution . — Achyuta Aich
– Achyuta Aich, Commented Feb 3, 2015 at 17:10
Where's the join condition? Parentheses aren't needed. You can alias specific tables not the join statement. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Feb 3, 2015 at 17:27
In my opinion natural join should be avoided because it is susceptible to side effects. Personally I would always use the more explicit join on — Hugh Jones
– Hugh Jones, Commented Feb 3, 2015 at 17:28

komodosp · Accepted Answer · 2015-02-03 17:13:58Z

1

The brackets around (pratip_Person natural join pratip_M_Director) are your problem!

Try

select t.name from pratip_Person natural join pratip_M_Director as t;

(unless the Q at the start is really part of your query!)

answered Feb 3, 2015 at 17:13

komodosp

3,6864 gold badges39 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Achyuta Aich Over a year ago

why is that a problem ? If we dont put he brackets then how can we identify whether t represents pratip_M_Director or the natural join ?

komodosp Over a year ago

I am not really sure how t could represent the natural join as opposed to either the pratip_M_Director table or the entire select statement... but the brackets being where they are now is causing the syntax error.

Panagiotis Kanavos Over a year ago

@jaig You alias tables, not join operations. A field can come either from Person or Director. If you have a column named Name in both, you need to specify whether you want the Person's or the Director's Name. Are you confusing the join with a subquery?

Strawberry Over a year ago

The closing parenthesis is in the wrong place. Also, the parentheses are completely redundant. But the parentheses in and of themselves aren't 'the problem'; just their positioning.

Collectives™ on Stack Overflow

MYSQL : an error in your SQL syntax

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related