CODEWITHSUNDEEP
sqlsql-servert-sql
SmartestVEGA
SmartestVEGA

Reputation: 8909

SQl to select from multiple tables

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 :-)

Upvotes: 0

Views: 233

Answers (2)

marc_s
marc_s

Reputation: 755451

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

Upvotes: 6

Halo
Halo

Reputation: 1532

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

Upvotes: 1

Related Questions