Re: SQL 'Select AS' syntax

On Jan 10, 2008 3:29 PM, Pete Helgren <Pete@xxxxxxxxxx> wrote:

I have an SQL statement where I select against a single file and use the
AS keyword and give it an ID. For example

Select field1, field2 from file1 as tbl

Then I use tbl as a reference in a later sub select statement. As was
well.

Now I need to change the initial select to select values from two files
and it no longer likes the AS. For example:

Select field1, field2, field3 from File1, File2 where key1 = key2 AS tbl

it goes immed after the file name.

I never use "as" since it is not needed. Just specify the as name immed
after the table name.

the as name works well as a single character that tells the reader the
ordinal of each table in the query. a for the first table, b for the 2nd,
etc.

on your query, I would code it as:
select a.field1, b.field2, b.field3
from File1 a
join File2 b
on a.key1 = b.key2

-Steve