Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. SELECT ems.v_Employee.EmployeeCode, ems.v_Employee.FirstName, ems.v_Employee.LastName, ems.v_Entity.EntityName, ems.v_BDActivity.ActivityDate,
  2. ems.v_BDActivity.BDActivity_ID, ems.v_BDActivity.Subject, ems.v_BDActivity.Details, ems.v_Contact.FirstName AS Expr1, ems.v_Contact.LastName AS Expr2,
  3. ems.v_ContactPosition.Position, ems.v_BDActivityEmployee.Employee_ID, ems.v_BDActivityContact.Contact_ID
  4. FROM ems.v_Contact INNER JOIN
  5. ems.v_BDActivityContact ON ems.v_Contact.Contact_ID = ems.v_BDActivityContact.Contact_ID INNER JOIN
  6. ems.v_Occupation ON ems.v_Contact.Contact_ID = ems.v_Occupation.Contact_ID INNER JOIN
  7. ems.v_ContactPosition ON ems.v_Occupation.ContactPosition_ID = ems.v_ContactPosition.ContactPosition_ID LEFT OUTER JOIN
  8. ems.v_Entity LEFT OUTER JOIN
  9. ems.v_BDActivity ON ems.v_Entity.Entity_ID = ems.v_BDActivity.Entity_ID ON ems.v_BDActivityContact.BDActivity_ID = ems.v_BDActivity.BDActivity_ID RIGHT OUTER JOIN
  10. ems.v_Employee INNER JOIN
  11. ems.v_BDActivityEmployee ON ems.v_Employee.Employee_ID = ems.v_BDActivityEmployee.Employee_ID ON
  12. ems.v_BDActivity.BDActivity_ID = ems.v_BDActivityEmployee.BDActivity_ID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement