Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Recordset Problem -- Left Join
I'm trying to execute a query that joins two Excel tables. I need all the
records in the first table and those in the second table that match the (2 field) key in the second table -- the typical LEFT JOIN query situation. Problem is, the recordset being returned only seems to bring back records that match on fields in BOTH tables, as if I were doing an equi-join. I don't understand this behavior, especially in light of my successful execution of a RIGHT JOIN query moments earlier in the code. Is there something I need to do to clear things out? Shown below is the SQL used in the query. Thanks for your help. SELECT T1.*, T2.* FROM tblEqpReportTLTempTbl As T1 LEFT JOIN TranDataActTblTLTempTbl As T2 ON (T1.TranName = T2.TranName AND T1.Fund = T2.Fund) WHERE T2.TranType ='DbtPro' There are 76 records in tblEqpReportTLTempTL and 39 records in TranDataActTblTLTempTbl that have TranType = 'DbtPro'. When I run the query I get a recordset returned with 39 records. I should be getting 76. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem copying ADO recordset to Excel 2003 | Excel Programming | |||
problem in seek value in recordset with index. | Excel Programming | |||
ADODB Recordset problem | Excel Programming | |||
Recordset Problem - object is closed | Excel Programming | |||
Conceptual Problem with DAO/ADO Recordset | Excel Programming |