Experts Exchange connects you with the people and services you need so you can get back to work.
Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.
select Mandoc.name, MDCPDS.name
inner join MDCPDS ON Mandoc.SSAN= MDCPDS.SSAN)
where Mandoc.name <> MDCPDS.name
Open in new window
In the Diagram pane of the Query Designer, drag the name of the join column in the first table or query and drop it onto the matching column in the second table or query.
In the Diagram pane, right-click the join line, and then click Properties.
On the Join Line tab, under Include rows, do one of the following:
To create a left outer join, select the first check box — for example, All rows from Mandoc.
To create a right outer join, select the second check box — for example, All rows from MDCPDS.
To create a full outer join, select both check boxes — for example, All rows from Mandoc and All rows from MDCPDS.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Be seen. Boost your question’s priority for more expert views and faster solutions