Advertisement
Guest User

Untitled

a guest
Aug 12th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. Select e.EMPLOYEEID, e.EMPLOYEEENAME, e.spouseid, s.SKILLTYPE, sl.SKILLID from Employee_t e, SKILL_T s, SKILLSET_T sl
  2. where e.EMPLOYEEID = sl.EMPLOYEEID AND s.SKILLID = sl.SKILLID and e.SPOUSEID is not null; --#1
  3.  
  4. Select * from DEPARTMENT_T d, Vendor_t v , EQUIPMENT_VENDOR_T el, EQUIPMENTS_T e
  5. where
  6. d.DEPARTMENTID = v.DEPARTMENTID and
  7. e.EQUIPMENTID = el.EQUIPMENTID and
  8. v.vendorid = el.VENDORID; --#2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement