1 echo select * from emp,dept;
2 select * from emp,dept;
3 echo select * from emp,dept where emp.ename LIKE 'K%';
4 select * from emp,dept where emp.ename LIKE 'K%';
5 echo select * from emp,dept where dept.dname LIKE 'S%';
6 select * from emp,dept where dept.dname LIKE 'S%';
7 echo select * from emp,dept where emp.ename LIKE 'K%' and dept.dname LIKE 'S%';
8 select * from emp,dept where emp.ename LIKE 'K%' and dept.dname LIKE 'S%';
9 echo select * from emp,dept where emp.ename LIKE 'K%' or dept.dname LIKE 'S%';
10 select * from emp,dept where emp.ename LIKE 'K%' or dept.dname LIKE 'S%';