Just did a quick test, i stand corrected. I thought that it may have been due to the fact i was trying to alias the same table more than once... but even that seems to work.
ahwell, i guess i just had a typo in my original query. cheers, _______________________ James Silva Web Production Gruden Pty Ltd Tel: +61 02 9956 6388 Fax: +61 02 9956 8433 Email: [EMAIL PROTECTED] Web: www.gruden.com _______________________ > James > > >> i initially tried using table aliases... access didn't approve :( > > hmmm...are you sure? > > SELECT a.nameAuthor,a.emailAuthor, a.levelAuthor > FROM tAuthor a > WHERE (((a.levelAuthor)>1)); > > works in Access SQL... > > cheers > barry.b --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
