Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Custom forms help on emagicone


Peper

Recommended Posts

Anyone familiar with this desktop program?

I need to alter a custom report and bit setback on the SQL part

SELECT T1.products_id,
       T2.products_name,
       T1.products_model,
       T1.products_barcode,
       T1.manufacturers_id,
       T1.products_price,
       T1.vendors_id
FROM /*PREFIX*/products T1 
     INNER JOIN /*PREFIX*/products_description T2 ON T2.products_id = T1.products_id
           And T2.language_id = /*CURRENT_LANGUAGE_ID*/  
WHERE T1.products_id /*PRODUCTS_ID_LIST*/ 
Order by vendors_id 

Above currently working except it is giving the vendors_id for the product ie. 5

I have a table called vendors, this have vendors_id and vendors name in it
How to make the products vendors_id show as vendors_name in above query?

Getting the Phoenix off the ground

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...