SHARE
TWEET

Untitled

a guest Aug 12th, 2017 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
Top