Hi,
Any particular reason why:
SELECT a.id, a.name, count (e.tid) as tCT
FROM tbl_a a left outer join tbl_e e ON a.id = e.id
WHERE a.id in (6,151,706) and
e.t_date = 'Apr 23 2007'
GROUP BY a.id, a.name
ORDER BY a.name
returns only one row for the a.id that matches the where clause while:
SELECT a.id, a.name, count (e.tid) as tCT
FROM tbl_a a, tbl_e e
WHERE a.id *= e.id and
a.id in (6,151,706) and
e.t_date = 'Apr 23 2007'
GROUP BY a.id, a.name
ORDER BY a.name
returns 3 rows as expected
Tested on both SQL 2000 and SQL 2005 and same result
Thanks
Victor
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276024
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
