Apologies - my mistake, typo in 'from' part:
from
tbl_cadidate,
tbl_vote as first,
tbl_vote as second,
tbl_vote as third
should be:
from
tbl_cadidate,
tbl_vote first,
tbl_vote second,
tbl_vote third
ooppso...
+----------------------------------------------------+
| VeriPay mPOS � Anywhere, Anytime |
| Puts money in your bank while you�re on the road |
| Secure Credit Card Transactions via SMS messaging |
| From Xilo Online www.xilo.com/mpos |
+----------------------------------------------------+
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of
> James Silva
> Sent: Tuesday, 22 July 2003 10:31 AM
> To: CFAussie Mailing List
> Subject: [cfaussie] RE: SQL fun
>
>
> 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/
---
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/
