Database Join « Join « SQL / MySQL






1.If the current database is database1 or database2, you can dispense with some of the qualifiers.
2.if the current database is database2, no database2 qualifiers are necessary
3.Qualify the table name with database name
4.Qualify the column name with table name and database name