• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:


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.

SELECT AdvApp.vPortfolio.PortfolioCode, AdvApp.vPortfolioTransaction.TradeDate, AdvApp.vPortfolioTransaction.TransactionCode
               AdvApp.vPortfolioTransaction ON AdvApp.vPortfolio.PortfolioID = AdvApp.vPortfolio.PortfolioID
WHERE (AdvApp.vPortfolioTransaction.TransactionCode = 'lo') AND (AdvApp.vPortfolioTransaction.TradeDate = '9/25/13')
  • 2
  • 2
1 Solution
QlemoBatchelor and DeveloperCommented:
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.
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.
QlemoBatchelor and DeveloperCommented:
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.
ShawnGrayAuthor Commented:
Excellent.  Thank you Qlemo.
Question has a verified solution.

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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now