Re: sql from access-pls analyze this error

[sunil kattathara]

Dear Bob,

in first example
FROM OrderDetails AS d
in second example
FROM Table1 AS t1

i understand...tables and quries can be represented using short alphanumaric representations
now since Table1 AS t1 already said in script...can we say...or logicaly right to say

SELECT t1.ContactAutoID, t1.Referedby AS Referedby1, t1a.Referedby AS Referedby2, t1b.Referedby AS Referedby3
FROM Table1 AS t1, t1a, t1b
LEFT JOIN t1a ON t1.Referedby = t1a.ContactAutoID
LEFT JOIN t1b ON t1a.Referedby = t1b.ContactAutoID;

thank you
Sunil