Gossamer Forum
Home : Products : DBMan SQL : Discussion :

SELECT QUESTION

Quote Reply
SELECT QUESTION
Hi,

does anyone know how I do the following?:

I have a table where the data of 30.000 products are stored. Also a StoreID is stored for every product.

Then I have a table with StoreNames,LogoURL,etc.

Now I want to display the right Store-Name and Logo for each Product based on the StoreID (StoreID is NOT a Primary Key in the tables products and stores).

It should be something like:

[<%ProductName%>] [<%ProductURL%>] [Display Logo and Shopname: Select Logo,Storename FROM stores WHERE stores.StoreID = products.StoreID]

I hope someone could help me.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Subject Author Views Date
Thread SELECT QUESTION ManuGermany 2014 Jan 7, 2003, 12:34 AM
Thread Re: [ManuGermany] SELECT QUESTION
604 1949 Jan 7, 2003, 10:16 AM
Post Re: [TheStone] SELECT QUESTION
ManuGermany 1938 Jan 7, 2003, 11:16 AM