2 # Testing Join on 5 sales tables.
3 # Create 5 tables like client_master,product_master,salesman_master,sales_order,sales_order_details.
4 # populate the above tables with required values.
5 # List the products which have been sold to 'Ivan Bayross'
7 QUITFILE
=${PWD}/sql
/Join
/quit.sql
11 REL_PATH
=`pwd`/sql
/Join
14 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_tables.sql
17 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql
21 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_join.sql
24 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql
28 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql