2 # Testing Join on 5 sales tables.
3 # select t1.f1,t1.f2,count(t1.f3),count(t2.f3) from t1,t2 group by t1.f1,t1.f2 ;
4 # This statement should work properly.
5 # select t1.f1,t1.f2,count(t1.f3),count(t2.f3) from t1,t2 group by t1.f1,t1.f2 having avg(t1.f2)<70;
6 # This statement should not work becoz expression in having clause not present in projection list.
9 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
13 REL_PATH
=`pwd`/sql
/Aggregate
16 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -s ${REL_PATH}/innerjoin_aggregate.sql
19 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1t2.sql
23 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1t2.sql