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.Portfoli oCode, AdvApp.vPortfolioTransacti on.TradeDa te, AdvApp.vPortfolioTransacti on.Transac tionCode
FROM AdvApp.vPortfolio LEFT OUTER JOIN
AdvApp.vPortfolioTransacti on ON AdvApp.vPortfolio.Portfoli oID = AdvApp.vPortfolio.Portfoli oID
WHERE (AdvApp.vPortfolioTransact ion.Transa ctionCode = 'lo') AND (AdvApp.vPortfolioTransact ion.TradeD ate = '9/25/13')
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.Portfoli
FROM AdvApp.vPortfolio LEFT OUTER JOIN
AdvApp.vPortfolioTransacti
WHERE (AdvApp.vPortfolioTransact
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.
Other than editing the SQL text, I can't figure out how to get the same fx symbol.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent. Thank you Qlemo.
You can also edit the query text, and click into the diagram pane to see the GUI change it is related to.