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.

Code:
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
Does this make sence?

Thanks