Correct SQL Syntax - which one ?

[karlomutschler]

Hi,
which one of the following is correct ?

sel *
from contract con
JOIN customer cus ON con.customer_id = cus.customer_id

OR

sel *
from contract con
JOIN customer cus ON cus.customer_id = con.customer_id

TIA
Kind regards
Karlo

 

[tlbroadbent]

Actually, either Select statement should work - at least they would in MS SQL Server. In other words...

Select * From ta join tb On ta.ID=tb.ID

is equivalent to

Select * From ta join tb On tb.ID=ta.ID
Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[Cagliostro]

for compatibility with some other databases is better to write also what kind of join, inner, outer(right or left), full. John Fill

ivfmd@mail.md