In my books I have not found a very good explaination for th

In my books I have not found a very good explaination for this but it is something that I would like to know. In some of my assignments I see questions written by my teacher that have things like c.CustomerID or c.EmailAddresses or a.CustomerID but I dont see these in the learnings in my book. What does the c. or a. mean in this code. I am trying to get a better understanding of how this all works.

Thanks

Solution

Here we use c or a in the like c.CustomerID or a.CustomerID, this means that we need to know about normalization. aThere is a chance of having similar field in two or more tables. If we want to perform any of the operation in those two tables we will create a alias name for the table. for example we have 2 tables like emp and cus tables. we have eid in both the tables. if we call eid frm which tables it should fectch the eid. to avoid these conflicts we will give alias name for tables. like a and b. if we call a.eid it means fetch eid frm a alias name table.