'FROM reallyReallyLongTableName AS a' syntax?

[jhardman]

I have a really long query, something like this:[code=sql]SELECT reallyReallyLon gTableName.id, reallyInsanelyL ongTableName.id
FROM reallyReallyLon gTableName, reallyInsanelyL ongTableName
WHERE reallyReallyLon gTableName.id = reallyInsanelyL ongTableName.id[/code]Except this is kind of pointless, obviously. The real query is much longer, but mostly because the tablenames are so long. Isn't there a way to give it an alias like this:[code=sql]SELECT a.id, b.id
FROM reallyReallyLon gTableName AS a, reallyInsanelyL ongTableName AS b
WHERE a.id = b.id[/code]I thought there was something like this, but I can't get this syntax to work. Obviously I can do AS a in the fieldnames portion, that isn't a problem, but in the tables?

Jared

[BHTanna]

U can use alias.. But without AS.

Like

<tablename> <alias>

eg.

reallyReallyLon gTableName a, reallyInsanelyL ongTableName b


Hope this will work.

[jhardman]

Thank you! that worked just fine!

Jared