When you wish to combine multiple tables and the tables have the same column name and you want to compare the data from these tables using the same column name, use the Using keyword rather than the On keyword.
How to Using keyword in PHP?
- To learn more about PHP's "inner" and "outer" joins. I'll now explain how to join tables using the "Using" keyword in this article. The "On" keyword is substituted with the term "Using".
- The designation table has two columns, but the emp table has four columns (id, fname, lname, and salary) (id and role). Now you can see that both tables contain a "id" field.
- It is typical for columns that are being compared to have the same name when you code a "equi join."
- The "Using" keyword can be used to make the query simpler for joins like these. The following example demonstrates the use of the "Using" keyword in place of the "On" keyword.
- Using their IDs, we connected two tables in the sample below. And the emp role will be returned from the designation database based on the name of the id column.
- If you want to combine multiple tables with the same column names and compare the data from these tables using the same column names, you can use the "Using" keyword rather than the "On" keyword, according to the explanation that came before. The keyword "Using" is usable.
To Learn more About Using keyword Refer to:
https://brainly.com/question/26355510
#SPJ4
