Link to home
Start Free TrialLog in
Avatar of ShawnGray
ShawnGray

asked on

LEFT OUTER JOIN

This LEFT OUTER JOIN creates the appropriate connection I'm looking for.

Can this be done using the 'diagram pane'
with Query Designer in MS Visual Studio,
I'm used to dragging fields from one table to another and selecting the join type.

This stmt shows the field from one table to the title bar of another table.
Learning,

SELECT AdvApp.vPortfolio.PortfolioCode, AdvApp.vPortfolioTransaction.TradeDate, AdvApp.vPortfolioTransaction.TransactionCode
FROM  AdvApp.vPortfolio LEFT OUTER JOIN
               AdvApp.vPortfolioTransaction ON AdvApp.vPortfolio.PortfolioID = AdvApp.vPortfolio.PortfolioID
WHERE (AdvApp.vPortfolioTransaction.TransactionCode = 'lo') AND (AdvApp.vPortfolioTransaction.TradeDate = '9/25/13')
Avatar of Qlemo
Qlemo
Flag of Germany image

Right-click on the rhomb displayed on the link between both tables, and select the first "Select All Rows from ..." to get a left (outer) join. Selecting the other option in addition will build full outer join, and selecting only the latter a right (outer) join.
You can also edit the query text, and click into the diagram pane to see the GUI change it is related to.
Avatar of ShawnGray
ShawnGray

ASKER

Thanks Qlemo, the script shown above puts a fx in the diamond.
Other than editing the SQL text, I can't figure out how to get the same fx symbol.
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Excellent.  Thank you Qlemo.