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

Thanks, got it sorted
 


Getting the Phoenix off the ground

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  

×