Michael Hunley <[EMAIL PROTECTED]> writes:
> I just ran into an annoying bug using SQLite 2.8.6 on Win XP compiled from
> source.
>
> If you do a select and use the "AS 'alias'" for a table and also do a "JOIN
> USING <col list>", you get a sql error: no such column <tablename>.<col
> name>. So, if you have table User with fields a,b and table UserInfo with
> fields a,c, the following gives the error "User.a no such column":
>
> SELECT U.b,I.c FROM User as U JOIN UserInfo as I USING a;
Try this alternate syntax:
SELECT U.b,
I.c
FROM User U,
UserInfo I
WHERE U.a = I.a;
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
