On Wed, 30 Jun 1999, Daniele Orlandi wrote:
>
> 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...
Of course it is...which username do you want to match on, users.username
or counters.username?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org