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 # Test join, aggregate and having on them by executing the following query:
6 # List the productno , descriptions and their totally_ordered_quantities(sum).test count,min,max also.
8 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
12 REL_PATH
=`pwd`/sql
/Aggregate
15 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -s ${REL_PATH}/sales_tables.sql
18 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -s ${REL_PATH}/sales_join_aggregate1.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql
29 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql