Ray Thompson wrote: > update table1 > set field1 = (select count(*) > from table2 > were table2.id = table1.id) > > Excellent! Aside from 'were' instead of 'where' *grin*, that was exactly what I needed. The way to do the ID match and aliases was what was throwing me.
Thanks much Ray! --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
