IF SQL Query

To the expert,

Need some help.

I have 2 tables:

Table1: prod_name, prod_type, colorcode
Table2: code_desc, code1, code2

I need to select all the record from Table1 where

prod_type = 0 then based on code1, display code_desc
prod_type=1 then based on code2, display code_desc

How do I create the SQL Query?

Thanks in advanced.

Microsoft SQL Server

Last Comment

Keng0499

8/22/2022 - Mon

Nitin Sontakke

4/9/2017

Sample data is always good to have...

Nitin Sontakke

4/9/2017

Hopefully something like this...however, it is not quite clear if colorcode matches only with 1 record or 2 records and you want both.

select prod_name, prod_type, colorcode, c1.code_desc, c2.code_desc
from table1 t1
left outer join table2 c1 on t1.colorcode = c1.code1
left outer join table2 c2 on t1.colorcode = c2.code2

Open in new window

Keng0499

4/9/2017

ASKER

prod_name, prod_type, colorcode
BrandA, 0, 98210223
BrandB, 0, 28934423
BrandC, 1, 29020192

code_desc, code1, code2
A_123, 98210223, 27832333-1
B_XYZ, 28934423, 92081245-T
PO30923, 82739344-XX, 29020192

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

ASKER CERTIFIED SOLUTION

HainKurt

4/9/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Keng0499

4/9/2017

ASKER

Thank.

BTW, what is c1 and c2?

Nitin Sontakke

4/9/2017

They are called table alias (just as there are column alias). We are using same table twice. Different table alias allow us to reference one table twice as if there are two different tables.

Keng0499

4/9/2017

ASKER

Thanks. Finally got it working :)

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

HainKurt

4/9/2017

you should select an answer and allocate points, not close it...

Keng0499

4/9/2017