>The WHERE clause makes me lose records from table1, if the table2.field3 is not greater than 5. If I start with 25 records in table1, I want to end up with 25 records in table1. Just want the field3 added if it mets the criteria, otherwise i want field3 to be blank.
>
>>Try
>>
>>SELECT Table1.Cust_No, Table1.Field1, Table1.Field2, Table2.Field3 ;
>> FROM Table1 LEFT OUTER JOIN Table2 ;
>> ON Table1.Cust_No = Table2.Cust_No ;
>> WHERE Table2.Field3 > 5
>>Regards,
>>Jim
>

In cases like this, you need to move the filter condition into the join condition:

SELECT Table1.Cust_No, Table1.Field1, Table1.Field2, Table2.Field3 ;
FROM Table1 LEFT OUTER JOIN Table2 ;
ON Table1.Cust_No = Table2.Cust_No ;
AND Table2.Field3 > 5

Tamar