At 05:20 PM 12/11/2003 -0500, [EMAIL PROTECTED] wrote:
Try this alternate syntax:
SELECT U.b,
I.c
FROM User U,
UserInfo I
WHERE U.a = I.a;
Thanks. I can work around it easily, but there are advantages to the AS
that might also be broken that could not be easily re-worked,
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 ", you get a sql error: no such column .. So, if you have table User with fields a,b and table UserInfo with
fields a,c, the
2 matches
Mail list logo
