2 # Testing Order by applying INNER JOIN and LEFT JOIN on multiple tables .
3 # This script is also for testing all the keywords supported for select query.
5 CREATEFILE
=${PWD}/sql
/Order
/dropt1.sql
7 if [ -s "$CREATEFILE" ]
9 REL_PATH
=`pwd`/sql
/Order
12 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/table_t1_t2_t3.sql
15 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop_t1_t2_t3.sql
19 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/order_inner_left.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop_t1_t2_t3.sql
26 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop_t1_t2_t3.sql