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),lid int);
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 where emp.deptno in (20,30,40); here emp.deptno is non existing field.
9 QUITFILE
=${PWD}/sql
/Join
/quit.sql
13 REL_PATH
=`pwd`/sql
/Join
16 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join34.sql
21 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join_in_notexist.sql
26 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop_emp_dept.sql