[thelist] combining two similar sql queries into one

Christie Mason cmason at managersforum.com
Fri Sep 18 11:30:29 CDT 2009

I'd suggest looking into derived tables.  I haven't done them with Oracle
but a quick Google indicated they're available in Oracle.

Basic idea w/b one derived table for parts and one for services then outer
link each to the other master tables as needed.

Christie Mason

More information about the thelist mailing list