The Hermit Hacker wrote:
>
> > tacacs=> SELECT * FROM users,counters WHERE users.username=counters.username
> > AND username='foobar';
> > ERROR: Column 'username' is ambiguous
> >
> > ...username is NOT ambiguous...
>
> Of course it is...which username do you want to match on, users.username
> or counters.username?
IMHO it's the same, since they have to be equal...
Pardon me if I'm not seeing something obvious :^)
Bye.
--
Daniele
-------------------------------------------------------------------------------
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------