I don't know what I'm doing wrong. Here is my Setup
ClientsOnePercent
-----------------
Autex
OnePctTypeID
AxysPals
--------
Autex
Quantity
SecType
Ticker
I want to show ALL rows from ClientsOnePercent where the OnePctTypeID = 1. I want to join it to the AxysPals table and show all Quantities that exist with each Autex where SecType = csus and Ticker = c. Not all Autex will have that sectype or ticker and I want it to show nothing if it does not exist in AxysPal. I thought a simple Left Outer Join would do the trick.
Here is my Select:
SELECT ClientsOnePercent.Autex, ClientsOnePercent.OnePctTypeID, AxysPals.Quantity
FROM ClientsOnePercent LEFT OUTER JOIN
AxysPals ON ClientsOnePercent.Autex = AxysPals.Autex
WHERE (ClientsOnePercent.OnePctTypeID = 1) AND (AxysPals.SecType = 'csus') AND (AxysPals.Ticker = 'c')
This does not give me all Autex from the ClientsOnePercent table. It will only shows me the ones that have the where clause.
Thanks in advance.
Phil
------------------------------
Using VS2010 / Learning in VB.Net / Win2008 R2 / SQL 2008 R2
Be kind to the newbies because you were once there.
Select all from one table JOIN
Posted - 10/15/2012 : 22:48:53
