Unless I'm missing something too obvious...
...WHERE A.type = TYPE.desc
No?
Kim.
> This is what I would like a single select to return rather doing two
selects:
>
> select A.*,TYPE.desc from A,TYPE where (the magic)
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST