Speaking of left outer joins: when you have a left outer join, and then you
put a condition for the right-hand-side table in the WHERE clause, then that
turns the LEFT OUTER JOIN into an INNER JOIN.
For exmaple, the following two queries will return the same result:
select ta.ta_id,
ta.columnA1,
ta.columnA2,
tb.tb_id,
tb.columnB1,
tb.columnB2
from tableA ta
left outer join tableB tb
on ta.ta_id = tb.tb_id
where tb.columnB1 = 100
select ta.ta_id,
ta.columnA1,
ta.columnA2,
tb.tb_id,
tb.columnB1,
tb.columnB2
from tableA ta
inner join tableB tb
on ta.ta_id = tb.tb_id
where tb.columnB1 = 100
So you might want to check whether a left join clause could have
been accidentally placed in the WHERE clause.
On Tue, Jul 8, 2008 at 4:16 PM, Richard White <[EMAIL PROTECTED]> wrote:
> >dont know if it may apply but to get that column i did a left join with
> another query and then from that query i did a union with another query
>
> so i will backtrack through all of these to see at what point it is changed
> and see where i can fix it
>
> thanks
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308791
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
