Re: FN-FORUM ASP select multiple tables
date posted 7th January 2003 22:38
if you can alter the database then do so, sounds a very bad db design if
you're grabbing the same fields for different products - far better to have
a 'product_type' table containing all the handhelds, systems... etc table
names with a 'products' table and then have a relationship between the 2
tables. from those 2 tables you can then build views to retrieve the data
in a much nicer looking, and much more efficient manner.
from the way your db set-up sounds you'll get issues when you have lots of
data requests.
on the other hand if its a client db and they're being recalcitrant over
having a proper db design then build relevant views and pray to any passing
deitys you dont get the blame when they whine about how long it takes to
process a request!
----- Original Message -----
From: [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Tuesday, January 07, 2003 8:52 PM
Subject: FN-FORUM ASP select multiple tables
> yet again I turn to the forum after a fruitless google.
>
> I have a database in which I need the select statement
> to access multiple tables. I have a solution but it seems
> rather clunky if I extend it as far as I need to. This works
> for two -
>
> SELECT Ref, Manufacturer, Model, Price, Category,
> Special_Offer, Special_Text FROM Laptops
> UNION SELECT Ref, Manufacturer, Model, Price, Category,
> Special_Offer, Special_Text FROM Handhelds, Systems
>
> I need to reference 10 tables all with the same selected
> field names in common. I know there must be and easier way
> could somebody point me in the right direction.
>
> tia,
>
> Darren Yates
> [EMAIL REMOVED]
> http://dittodesign.co.uk
>
>
>
>
>
> ========
> Advertise with Freelancers.net +Additions+
> http://www.freelancers.net/advert.php
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
