Category
- Php
- JAVA
- DOTNET
- Vbscript
- C
- vb
- html
- Mysql
- Oracle
- sql
- Db
- Computer
- Commerce
- Business
- Arts
- Cashier
- Audit
- Banking
- Accounts
- Math
- Physics
- Biology
- Others
Home >> Asked Questions >> Mysql
Q. How does a MYSQL Self-Join Work?
Answer :
In self join we create a alias of table then join of tables
Examples-
select * from table1 as t1 table1 as t2 where t1.id=t2.pid
Examples-
select * from table1 as t1 table1 as t2 where t1.id=t2.pid
Posted By : app101
Most Viewed Questions