General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only