Results 1 to 8 of 8
Thread: Joining Query
Apr 23, 2004, 16:01 #1
- Join Date
- Jul 2003
- True North
- 0 Post(s)
- 0 Thread(s)
Ok, I dont Know If I can do this.
I have 2 Tables, suppliers and accounts.
Suppliers contain supplier_number, supplier_name.
Accounts contain supplier_number, customer_number, account_number.
I am using customer_number 268 for example. When I query the Access DB I would Like all supplier_numbers, supplier_names from the suppliers table where customer_number 268 is present in the accounts table.
SELECT suppliers.supplier_number, suppliers.supplier_name, accounts.account_number FROM suppliers INNER JOIN suppliers ON suppliers.supplier_number = accounts.supplier_number WHERE accounts.customer_number = 268