Peper Posted June 15, 2020 Share 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 Link to comment Share on other sites More sharing options...
♥ecartz Posted June 15, 2020 Share 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. Link to comment Share on other sites More sharing options...
Peper Posted June 15, 2020 Author Share Posted June 15, 2020 Thanks, got it sorted Getting the Phoenix off the ground Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.