I have a query that looks something like...
SELECT t.FirstCollumn,
(SELECT moreStuff) AS SecondCollumn
FROM SomeTables t
And it works fine, however when the result of the sub-query is Null I want
to omit the rows from the final results but neither WHERE or HAVING are
valid when refering to the collumn SecondCollumn. I can use...
WHERE FirstColumn = SomeValue
Just fine, but trying to use
WHERE SecondCollumn = SomeValue
Return the error "Invalid column name 'SecondCollumn'."
Does anyone know why and more importantly how to get arround this?
--
James Smith - IT Director
uWish Ltd - http://www.uWish.co.uk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270441
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
