today:
827
yesterday:
824
Total:
1,856,304

Technology

INNER Join

admin 2018.09.29 16:17 Views : 329

 

SELECT * 

FROM emp INNER JOIN dept

ON emp.deptno = dept.deptno

 

SELECT *

FROM emp,dept

WHERE emp.deptno = dept.deptno