I don't know what SQL standards say about this, but in:
tacacs=> SELECT * FROM users,counters WHERE users.username=counters.username AND
username='foobar';
ERROR: Column 'username' is ambiguous
...username is NOT ambiguous...
Bye!
--
Daniele
-------------------------------------------------------------------------------
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------