Re: SQL question

Wilco,

Thanks, but your query is returning a row for each LIC_STATUS row associated with the LIC row. I only want one row per license showing the most current status if available, otherwise displaying null for the LIC_STATUS columns. I can do this using a UNION. I don't know how efficient that is but it does work with one major qualification. I need to use TO_NULL( NULL ) in one of the queries but I get an ORA-00904 ' invalid column name' when I do. Always something <g>.

--
Jim Poe
<jpoe_at_fulcrumit.com>
Fulcrum InteTech, Inc. Received on Tue Jul 20 1999 - 16:24:33 CDT