dcsimg
Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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

WEBINAR:

On-Demand

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


Joining Syntax, Table Alias, and the As keyword

Question:
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.)

Answer:
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.

 

 

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