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.
Does this make sence?Code:
ON suppliers.supplier_number = accounts.supplier_number
WHERE accounts.customer_number = 268