Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Joins in 8i
"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