SQl to select from multiple tables

Question

I have two table emptable1(empid,status) emptable2(empid,week)

i want to select all the empid whose status is 0 in emptable1 and from that list of empid i need to select empid whose week is 7 from the table emptable2

Please help :-)

marc_s · Accepted Answer · 2010-03-12 12:18:08Z

6

Not knowing your table structure in detail, but this ought to work:

SELECT  
    (fields)
FROM 
    dbo.emptable1 e1
INNER JOIN
    dbo.emptable2 e2 ON e1.empid = e2.empid
WHERE 
    e1.status = 0
    AND e2.week = 7

answered Mar 12, 2010 at 12:18

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Comments

Halo · Accepted Answer · 2010-03-12 12:17:20Z

1

How about using join? Join the two, then do your logic implementation altogether.

answered Mar 12, 2010 at 12:17

Halo

1,5323 gold badges24 silver badges40 bronze badges

Collectives™ on Stack Overflow

SQl to select from multiple tables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related