SQL query adding rows on result - sql server 2012

Question

In my Order table I have for each Order three tasks (id_task). If an id_address matches id_address 14 then I want to show all the tasks of that specific id_order.

id_order | id_task | id_address
 1       |   556   | 12
 1       |   557   | 14 
 1       |   558   | 11
 2       |   559   | 56
 2       |   560   | 88 
 2       |   561   | 77

results when I match id_address = 14

id_order | id_task | id_address
 1       |   556   | 12
 1       |   557   | 14 
 1       |   558   | 11

How do I do this?

I do now:

select id_order, id_task, id_address
from order
where id_address = 14

Of course this doesn't work. I will only get task 557. But I also want to have the other results from id_order. But how?

Tedo G. · Accepted Answer · 2016-10-28 07:35:21Z

3

Here is the simple solution:

select 
      id_order
    , id_task
    , id_address 
from 
    [order] 
where 
    id_order IN (
            select 
                id_order 
            from 
                [order] 
            where   
                id_address = 14)

answered Oct 28, 2016 at 7:35

Tedo G.

1,5653 gold badges18 silver badges32 bronze badges

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

Comments

Giorgos Betsos · Accepted Answer · 2016-10-28 07:37:44Z

2

You can use EXISTS:

select id_order, id_task, id_address
from order t1
where exists (select 1
              from order t2
              where t1.id_order = t2.id_order and t2.id_address = 14)

answered Oct 28, 2016 at 7:37

Giorgos Betsos

72.3k10 gold badges69 silver badges103 bronze badges

Comments

neer · Accepted Answer · 2016-10-28 07:48:21Z

0

You can as the below:

SELECT 
    A.* 
FROM 
    Order A INNER JOIN 
    Order B ON A.id_order = B.id_order 
WHERE
    B.id_address = 14

answered Oct 28, 2016 at 7:48

neer

4,0926 gold badges22 silver badges34 bronze badges

Collectives™ on Stack Overflow

SQL query adding rows on result - sql server 2012

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related