Re: [HACKERS] Little Suggestion for 6.6

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.comViaMezzera 29/A - 20030 - Seveso (MI) - Italy
 
-------------------------------------------------------------------------------