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


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

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