>
Have table1 with cust_no, field1, field2. table2 has cust_no, field3. want to create a table with table1 fields and table2.field3 if field3 > 5. Want to end up with the same number of record from table1.
>
>The WHERE field3 > 5 makes me lose records from table1.
>
>thanks
>
>BrendaBrenda,
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