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.stateFROM 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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: