I have inherited an app which has an old query that's now not working, because the new database we're using doesn't have backwards compatibility set. I could ask the sysadmin to set backwards compatiblity but i'd rather correct the query to use current syntax.
My question is, since this syntax is old and dates back to about the time I came into this game, can someone help me be certain what this query is supposed to be doing? Here's the query as written, that's now giving an error: SELECT o.*, s.name+' | '+s.subname AS status, u.uOrgName AS custName, c.cCountry AS dest_country, io.fk_invoice FROM nw_orders o, nw_order_status s, nw_users u, nw_country c, nw_invoice_orders io WHERE o.fk_user=u.pk AND o.delivery_country=c.pk AND io.fk_order=*o.pk AND o.fk_order_status=s.pk ORDER BY dt_created DESC The bit that's making SQLServer barf is the AND io.fk_order=*o.pk So before I go tinkering about with this query I need to be sure what it's supposed to do. So what's the current syntax equivalent to this query please? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2913 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
