Alysia,
><cfquery name="Programs" datasource="#dsn#" username="#dbuser#" >
>
>select p.PROG_EMPH_ID, l.PROG_RL_DESCRIPTION,
> l.PROG_RL_LINK, l.PROG_REC_ID, l.PROG_LINK_LKUP_REC_ID, p.PROG_REC_ID
>from PROGRAMS p and PROG_RELATED_LINKS l
> where p.PROG_REC_ID = l.PROG_REC_ID
> and p.prog_emph_id = 1
> and l.PROG_LINK_LKUP_REC_ID = 3
> </cfquery>
>
It looks like you have an "and" in your FROM clause that shouldn't be there.
select p.PROG_EMPH_ID,
l.PROG_RL_DESCRIPTION,
l.PROG_RL_LINK,
l.PROG_REC_ID,
l.PROG_LINK_LKUP_REC_ID,
p.PROG_REC_ID
from PROGRAMS p, PROG_RELATED_LINKS l
where p.PROG_REC_ID = l.PROG_REC_ID
and p.prog_emph_id = 1
and l.PROG_LINK_LKUP_REC_ID = 3
You could alternatively write this as :
select p.PROG_EMPH_ID,
l.PROG_RL_DESCRIPTION,
l.PROG_RL_LINK,
l.PROG_REC_ID,
l.PROG_LINK_LKUP_REC_ID,
p.PROG_REC_ID
from PROGRAMS p
LEFT JOIN PROG_RELATED_LINKS l ON p.PROG_REC_ID = l.PROG_REC_ID
where p.prog_emph_id = 1
and l.PROG_LINK_LKUP_REC_ID = 3
Hope this helps
Regards
Stephen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:508
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
