Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT emp.fname, emp.lname, emp.hdate, pos.title, emp.salary
- FROM emp
- INNER JOIN pos ON emp.posid = pos.posid
- WHERE emp.gender = "M" AND (emp.fname LIKE 'J%' OR emp.fname LIKE 'B%') AND emp.hdate>= '2000-12-09' AND emp.salary > 35000
Add Comment
Please, Sign In to add comment