> SELECT sa.*, > 'acr' as propertyType > FROM smlc_acr sa
I don't understand that, Dominic. What does the 'acr' refer to? > -----Original Message----- > From: Dominic Watson [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 24, 2008 8:24 AM > To: CF-Talk > Subject: Re: Need some advice on speeding up query... > > > If I did that for the "commercial properties" table, then I'd have a > > property_type > > field in each property table that I could add to the url link and pass to > > the > > property details page to specify which table to search for the property. > > I don't think you would need to add the property type field. The table > is the property type right? So, when you select from a given table, > you can just select a string to represent the property type: > > SELECT sa.*, > 'acr' as propertyType > FROM smlc_acr sa > > UNION ALL > > SELECT sc.*, > 'com' as propertyType > FROM smlc_com sc > > etc > > (I only put the select * for readability in this example). > > HTH > > Dominic > > -- > Blog it up: http://fusion.dominicwatson.co.uk > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4