Normalization has left me confused...

[Anon]

Ok, I went through the process of normalization as its something I should do... now I can't get a single select to work the way I want it to lol

As an example how would I do the following:

Table A contains product names and ids
Table B contains a list of product properties and their ids
Table C contains the relationships between the properties and the products

Now how would I search for a product name and have it display the name and the properties?

SELECT name,property FROM tableA,tableB,tableC WHERE products.prodName='$searchstring' AND relationships.relProdId=products.prodId AND properties.property=relationships.relPropertyId

this should work in theory... however how do you get the data out? or did it return data or am I just a complete moron and you're laughing? 🙂

Mark

[Anon]

Don't you have to do:

SELECT name,property FROM tableA as products,tableB as properties,tableC as relationships WHERE products.prodName='$searchstring' AND relationships.relProdId=products.prodId AND properties.property=relationships.relPropertyId

?

Or change the stuff in the where clause to use tableA, tableB and tableC.

Diego

[Anon]

my bad...

see how confused I am, I can't keep my example strait from my code lol

the select should have read as:

SELECT name,property FROM tableA,tableB,tableC WHERE tableA.prodName='$searchstring' AND tableC.relProdId=tableA.prodId AND tableB.property=tablec.relPropertyId

Still doesn't work though 🙁

[Anon]

I think you have to specify the tables for the SELECT fields:

SELECT tableA.name, tableB.property (or whatever they belong to)

Diego