I don't know what I'm doing wrong. Here is my SetupClientsOnePercent-----------------AutexOnePctTypeIDAxysPals--------AutexQuantitySecTypeTickerI 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.QuantityFROM ClientsOnePercent LEFT OUTER JOIN AxysPals ON ClientsOnePercent.Autex = AxysPals.AutexWHERE (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 R2Be kind to the newbies because you were once there.