Jump to content
Sign in to follow this  
Peper

Custom forms help on emagicone

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

Share this post


Link to post
Share on other sites
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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×