Peper 13 Posted June 15, 2020 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 Share this post Link to post Share on other sites
♥ecartz 682 Posted June 15, 2020 INNER JOIN vendors v on T1.vendors_id = v.vendors_id Then you can select v.vendors_name. Always back up before making changes. Share this post Link to post Share on other sites
Peper 13 Posted June 15, 2020 Thanks, got it sorted Getting the Phoenix off the ground Share this post Link to post Share on other sites