Re: sql from access-pls analyze this error

[Bob Field]

This one is actually quite clean. The parentheses are unnecessary since the normal order of operations is left-to-right.

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

My personal preference is to select short mnemonic table aliases for a compact appearance and less typing.