"Six to one. . . ."
"Aaron Rouse" <aaron_rouse_at_yahoo.com> wrote in message
news:a57b6daf.0111301951.3c82ad7a_at_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 - 22:43:09 CST
