Re: SQL Joins in 8i

SELECT q.id, q.frm, q.question, q.qtype, L.name, q.sortorder FROM FRMQUESTIONS q,

             (select * from PICKLISTS where PID <> 0 ) L WHERE q.LISTID(+) = L.PID
ORDER BY q.sortorder Received on Fri Nov 30 2001 - 16:07:17 CST