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

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.

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

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

Collectives™ on Stack Overflow

Selecting multiple values with multiple where clauses

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related