test/sql/Join/exp.test015.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 echo select * from emp,dept;
  12 ---------------------------------------------------------
  13         emp.eno emp.ename       emp.dno dept.deptno     dept.dname
  14 ---------------------------------------------------------
  15         1       Nihar   10      20      Sales
  16         1       Nihar   10      40      Mkt
  17         1       Nihar   10      35      HR
  18         2       Kishore 20      20      Sales
  19         2       Kishore 20      40      Mkt
  20         2       Kishore 20      35      HR
  21         3       Jiten   30      20      Sales
  22         3       Jiten   30      40      Mkt
  23         3       Jiten   30      35      HR
  24         4       Bijay   40      20      Sales
  25         4       Bijay   40      40      Mkt
  26         4       Bijay   40      35      HR
  27         5       Kailash 50      20      Sales
  28         5       Kailash 50      40      Mkt
  29         5       Kailash 50      35      HR
  30
  31 echo select * from emp,dept where emp.ename LIKE 'K%';
  32 ---------------------------------------------------------
  33         emp.eno emp.ename       emp.dno dept.deptno     dept.dname
  34 ---------------------------------------------------------
  35         2       Kishore 20      20      Sales
  36         2       Kishore 20      40      Mkt
  37         2       Kishore 20      35      HR
  38         5       Kailash 50      20      Sales
  39         5       Kailash 50      40      Mkt
  40         5       Kailash 50      35      HR
  41
  42 echo select * from emp,dept where dept.dname LIKE 'S%';
  43 ---------------------------------------------------------
  44         emp.eno emp.ename       emp.dno dept.deptno     dept.dname
  45 ---------------------------------------------------------
  46         1       Nihar   10      20      Sales
  47         2       Kishore 20      20      Sales
  48         3       Jiten   30      20      Sales
  49         4       Bijay   40      20      Sales
  50         5       Kailash 50      20      Sales
  51
  52 echo select * from emp,dept where emp.ename LIKE 'K%' and dept.dname LIKE 'S%';
  53 ---------------------------------------------------------
  54         emp.eno emp.ename       emp.dno dept.deptno     dept.dname
  55 ---------------------------------------------------------
  56         2       Kishore 20      20      Sales
  57         5       Kailash 50      20      Sales
  58
  59 echo select * from emp,dept where emp.ename LIKE 'K%' or dept.dname LIKE 'S%';
  60 ---------------------------------------------------------
  61         emp.eno emp.ename       emp.dno dept.deptno     dept.dname
  62 ---------------------------------------------------------
  63         1       Nihar   10      20      Sales
  64         2       Kishore 20      20      Sales
  65         2       Kishore 20      40      Mkt
  66         2       Kishore 20      35      HR
  67         3       Jiten   30      20      Sales
  68         4       Bijay   40      20      Sales
  69         5       Kailash 50      20      Sales
  70         5       Kailash 50      40      Mkt
  71         5       Kailash 50      35      HR
  72
  73 echo drop table emp;
  74 Statement Executed
  75 echo drop table dept;
  76 Statement Executed