Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ems.v_Employee.EmployeeCode, ems.v_Employee.FirstName, ems.v_Employee.LastName, ems.v_Entity.EntityName, ems.v_BDActivity.ActivityDate,
- 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,
- ems.v_ContactPosition.Position, ems.v_BDActivityEmployee.Employee_ID, ems.v_BDActivityContact.Contact_ID
- FROM ems.v_Contact INNER JOIN
- ems.v_BDActivityContact ON ems.v_Contact.Contact_ID = ems.v_BDActivityContact.Contact_ID INNER JOIN
- ems.v_Occupation ON ems.v_Contact.Contact_ID = ems.v_Occupation.Contact_ID INNER JOIN
- ems.v_ContactPosition ON ems.v_Occupation.ContactPosition_ID = ems.v_ContactPosition.ContactPosition_ID LEFT OUTER JOIN
- ems.v_Entity LEFT OUTER JOIN
- 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
- ems.v_Employee INNER JOIN
- ems.v_BDActivityEmployee ON ems.v_Employee.Employee_ID = ems.v_BDActivityEmployee.Employee_ID ON
- ems.v_BDActivity.BDActivity_ID = ems.v_BDActivityEmployee.BDActivity_ID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement