Re: SQL Joins in 8i

From: Aaron Rouse <aaron_rouse_at_yahoo.com>
Date: 30 Nov 2001 19:51:24 -0800
Message-ID: <a57b6daf.0111301951.3c82ad7a@posting.google.com>

"Forrest Cicogni" <fcicogni_at_sageasset.com> wrote in message news:<1007143872.855613_at_news>...
> 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

Thanks, I actually figured out something similar to this shortly after posting to the group. Only real difference in what I did was != 0 instead of <> 0 Received on Fri Nov 30 2001 - 21:51:24 CST