Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL Server
Expertise: Beginner
Jul 8, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Joining Syntax, Table Alias, and the As keyword

Are there any special consideration when using an Inner Join and two of the same tables, one used as an alias? What is the ANSI SQL-specific syntax for Inner Join, for example? (I'm connected to an Informix database via Microsoft Access 97.)

You'd be wise to name both uses of the table differently. The alias name has to come before the INNER JOIN keyword, like this:

from authors as writers inner join authors as cowriters...
The syntax from BOL:
SELECT p.pub_name, p.state, a.au_lname, a.au_fname, a.state
FROM publishers p INNER JOIN authors a
    ON a.state > p.state
I'm not certain, but I thought ODBC at least catered to lowest common denominators to get the same response (if not performance) from server differences.
DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date