Azadi, Dominic... One thing I did notice is that the db vendor didn't put a field for the property type in the commercial properties table. When I transfer the data from my "temp" table (created when I import the vendor's data from their text file) I would need to add a "property_type" field for the permanent table, along with the "property_id" field I've already added.
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. Thanks for the input! Rick > -----Original Message----- > From: Dominic Watson [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 24, 2008 5:36 AM > To: CF-Talk > Subject: Re: Need some advice on speeding up query... > > This is a common problem. It sounds like having a single table with all of > the fields plus an extra field for the property 'type' may be a good idea - > or, in you Union query, select the property type for each row and pass that > in the Url, so: > > select sa.street_number as prop_street_number...etc > 'acr' as propertyType > from smlc_acr > > union all > > select sa.street_number as prop_street_number...etc > 'com' as propertyType > from smlc_com > > HTH > > Dominic > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
