sql query by passing te values in one table

Question

can any one help me in generating query for the below scenario?

i have twop tables TableA and TableB

TableA has teh follwing columns EMPLOYEEID, SKILLSETCODE,CERTID, LASTNAME, FIRSTNAME, MIDDLEINITIAL

TableB has two columns EMPLOYEEID and key_user

i want to SELECT EMPLOYEEID, SKILLSETCODE,CERTID, LASTNAME, FIRSTNAME, MIDDLEINITIAL FROM TableA WHERE EMPLOYEEID = (select employeeid from TableB where key_user='249')

how can i generate a sql query for the above scenario?

Answer 1

Use a join.

SELECT TableA.EMPLOYEEID, SKILLSETCODE,CERTID, LASTNAME, FIRSTNAME, MIDDLEINITIAL 
FROM TableA, TableB
WHERE TableA.EMPLOYEEID = TableB.employeeid 
and TableB.key_user='249'

Answer 2

Alternately

SELECT TableA.EMPLOYEEID, SKILLSETCODE,CERTID, LASTNAME, FIRSTNAME, MIDDLEINITIAL 
FROM TableA
  INNER JOIN TableB
    ON TableA.EMPLOYEEID = TableB.employeeid 
WHERE TableB.key_user='249'