2 #Testing LIKE operator in Join
3 #create table emp(eno int,ename char(10),dno int);
4 #create table dept(deptno int,dname char(10));
5 #insert some records into both the tables.
6 #Test the following Select statements using join and BETWEEN operator and check the retrieved data are proper or not
7 #select * from emp,dept where emp.ename LIKE 'K%';
8 #select * from emp,dept where dept.dname LIKE 'S%';
9 #select * from emp,dept where emp.ename LIKE 'K%' and dept.dname LIKE 'S%';
10 #select * from emp,dept where emp.ename LIKE 'K%' or dept.dname LIKE 'S%';
12 QUITFILE
=${PWD}/sql
/Join
/quit.sql
16 REL_PATH
=`pwd`/sql
/Join
19 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join33.sql
24 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join_like.sql
29 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop_emp_dept.sql