In a SQL query without the dynamic column list, is this what you are trying to achieve?
SELECT u.id FROM users u INNER JOIN users_updated up ON u.id = up.id AND up.lastupdated >= <cfqueryparam cfsqltype="cf_sql_date" value="#since#"> WHERE u.id IN ( SELECT id FROM USER_UPDATE up1 WHERE u.cola <> up1.cola OR u.colb <> up1.colb OR u.colc <> up1.colc OR etc <> etc ) Rich Kroll ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4