Try this...
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
because you're using username in the query call, I doubt you'll need
to identify the schema in the query itself.
In aliasing we're referencing PROGRAMS with p and PROG_RELATED_LINKS with l.
So when you use those tables you can reference them using the alias l and p.
On Tue, 23 Nov 2004 10:18:36 -0400, alysia brown <[EMAIL PROTECTED]> wrote:
> Ok I've cleaned it up but cannot comprehend how to so the aliasing so I have
> left that part as is. Code is below. But I still get an error which can be
> found at:
> http://web-dev.csrees.usda.gov/newsroom/news/ag_biosecurity/testing.cfm
>
> <cfquery name="Programs" datasource="#dsn#" username="#dbuser#" >
> select PROGRAMS.PROG_EMPH_ID,
> PROG_RELATED_LINKS.PROG_RL_DESCRIPTION,
> PROG_RELATED_LINKS.PROG_RL_LINK,
> PROG_RELATED_LINKS.PROG_REC_ID, PROG_RELATED_LINKS.PROG_LINK_LKUP_REC_ID,
> PROGRAMS.PROG_REC_ID
> from #dbuser#.PROGRAMS and #dbuser#.PROG_RELATED_LINKS
> where PROGRAMS.PROG_REC_ID =
> PROG_RELATED_LINKS.PROG_REC_ID
> and PROGRAMS.prog_emph_id = 1
> and PROG_RELATED_LINKS.PROG_LINK_LKUP_REC_ID = 3
> </cfquery>
>
> <cfoutput query ="Programs">
> <Ul>
> <li>#PROG_RELATED_LINKS.PROG_RL_DESCRIPTION#
> </li>
> </Ul>
> </cfoutput>
> </body>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:498
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
