SQl to select from multiple tables

Posted by SmartestVEGA on Stack Overflow See other posts from Stack Overflow or by SmartestVEGA
Published on 2010-03-12T12:15:11Z Indexed on 2010/03/12 12:17 UTC
Read the original article Hit count: 301

Filed under:
|
|
|

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

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server