Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select e.EMPLOYEEID, e.EMPLOYEEENAME, e.spouseid, s.SKILLTYPE, sl.SKILLID from Employee_t e, SKILL_T s, SKILLSET_T sl
- where e.EMPLOYEEID = sl.EMPLOYEEID AND s.SKILLID = sl.SKILLID and e.SPOUSEID is not null; --#1
- Select * from DEPARTMENT_T d, Vendor_t v , EQUIPMENT_VENDOR_T el, EQUIPMENTS_T e
- where
- d.DEPARTMENTID = v.DEPARTMENTID and
- e.EQUIPMENTID = el.EQUIPMENTID and
- v.vendorid = el.VENDORID; --#2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement