I found it easy from SQL statement and when I was constructing the notations I started visa versa i.e. specifying unique ID for both table instead of criteria first. Is is necessary to define table.attribute i.e. Customer.CustomerCode when working with only one table?
I have two tables, customer and product, I think to be able to know which customer by certain product, the Customer.Code on Product table will be foreign key from Customer table. Sorry, I am taking my course assignment and new to databases.