Re: FN-FORUM ASP select multiple tables

date posted 7th January 2003 23:04

> 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.

ok cheers but changing the databse at this stage will mean going back
through the site and doing a fair bit of editing. As it stands the tables
will
only ever contain six to a maximum of ten records each so it shouldn't
cause any headaches.

> from the way your db set-up sounds you'll get issues when you have lots of
> data requests.

The multiple table query I need to do just grabs special offers across
the tables. This is the one and only time multiple tables will
be accessed in one go and it only needs to return three to five records.

As I said in my last mail it seemed the easiest way to keep track of
products to have a table per product for such a small database.

cheers,

Darren





----- Original Message -----
From: "David Eckersall" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Tuesday, January 07, 2003 10:39 PM
Subject: Re: FN-FORUM ASP select multiple tables


> 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]
>
>
> ========
> 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]