Selecting multiple values with multiple where clauses

Question

I want to select multiple column values based on multiple where clauses in SQL. I am not able to do it.

I am trying something like,

select c.fname,r.fname from customer as c LEFT JOIN retailer as r ON
r.customer_id = c.id where c.id > 10 OR r.id < 50.

Basically I want both my where clauses to get executed one by one and first output(when 'where c.id>10' is executed) should come as c.fname and second output (when 'where r.id<50') in one sql query.

Can it be done ? Please help.

I can not understand, you want all this in same result ? For both where clause ? — Ronak Joshi
– Ronak Joshi, Commented Dec 22, 2015 at 11:19

Shadow · Accepted Answer · 2015-12-22 11:24:43Z

0

I think you need a union, not a join:

select c.fname, 'customer' as type from customer as c where c.id > 10
union
select r.fname, 'retailer' from retailer as r where r.id < 50

This would give you the list from both tables, independently from each other, within 1 query.

answered Dec 22, 2015 at 11:24

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ozair Kafray · Accepted Answer · 2015-12-22 11:56:52Z

0

Try the following query:

SELECT
c.fname,
r.fname
CASE WHEN r.id < 50 THEN 'output 1'             
     WHEN c.id > 10 THEN 'output 2' END AS 'OUTPUT_COLUMN'
FROM customer as c 
LEFT JOIN retailer as r 
ON r.customer_id = c.id

edited Dec 22, 2015 at 11:56

Ozair Kafray

13.6k8 gold badges61 silver badges85 bronze badges

answered Dec 22, 2015 at 11:21

Anil Panwar

2,6221 gold badge13 silver badges24 bronze badges

Collectives™ on Stack Overflow

Selecting multiple values with multiple where clauses

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related