How to get two values from one table in ms access

select CustomerTable.field1,CustomerTable.field2,SaleTable.field1,SaleTable.field2 from CustomerTable,Sales table where SaleTable.CustomerId=CustomerTable.CustomerId and SaleTable.CustomerID=23423;

You can switch to an SQL mode/view and enter something like the above. You can obviously name any columns you want in the first part.