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')
ShawnGrayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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.
0
ShawnGrayAuthor Commented:
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.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The "fx" symbol is veeery bad to see in your case. It appears if the Query Designer is not able to directly map two columns for the join condition, like in ON tblA.A = tblB.A+'x'. You should never have that for a simple one-by-one join like ON tblA.A = tblB.A. You will also note that that symbol's endpoints are the table, and no column.
You will not be able to get the fx by just dragging relations, or editing properties; only by changing the query text directly.

So, you usually click on the column on one table, and drag it to a column of the other table, to buld a (equal) join condition. You can modify the properties of the rhomb then to make it an outer join, and/or to change from equal to e.g. not equal, greater than, and the like.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShawnGrayAuthor Commented:
Excellent.  Thank you Qlemo.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.