Hi, I've the following table design (attached txt file, for some reason the content was being blocked) and I'd like any advice if this is the correct method/design. Thanks for any comments. Neil _________________________________________________________________ Play and win great prizes with Live Search and Kung Fu Panda http://clk.atdmt.com/UKM/go/101719966/direct/01/
TableName:ProductMaster ProductMasterID FriendlyProductName
TableName:ProductContent ProductContentID ProductName Site Language TableName:ProductLookup ProductLookupID ProductContentID TableName:Products ProductsID ProductSupplier Cost Below is my query extracting the data : SELECT ProductName, ProductSupplier FROM Products INNER JOIN ProductLookup ON ProductMaster.ProductMasterID = ProductLookup.ProductLookup INNER JOIN Products ON ProductLookup.ProductID = Products.ProductsID INNER JOIN ProductContent ON Products.ProductsID = ProductContent.ProductContentID WHERE ProductMaster.ProductMasterID = 1 AND ProductContent.Site = "mysite.com" AND ProductContent.Language = "eng"
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
