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

Brenda