Saturday, November 17, 2012 11:55 AM
i have two tables , tblUser , tblJobAdv
user id (pk) advId
Now i want to select all columns from tblJobAdv for only those userid's for which email = 'firstname.lastname@example.org' , in tblUser,
i did my best but spent 4 hours and couldn't achieve anything , Help !
Saturday, November 17, 2012 4:43 PM
SELECT tblJobAdv.advid, tblJobAdv.date, tblJobAdv.userID
FROM tblUser INNER JOIN
tblJobAdv ON tblUser.userID = tblJobAdv.userID
WHERE (tblUser.email = Nemail@example.com')
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.