Fully Qualified name

Question

What is fully Qualified name and its uses Explain ?

Answer 1

As an example, this would include the table name as well as the table field. When performing a join on multiple tables there are potential name conflicts (e.g. both tables may have a column called 'id'). In this case you must use the fully qualified name, like table1.id instead of just id