Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

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



Application Security Testing: An Integral Part of DevOps

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.



We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date