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