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