2 # Create two tables, having same fieldnames say f1,f2 in both the tables.
3 # Testing projection fieldname without tablename in joinint the two table.
4 # for ex : select f1 from t1,t2;
5 # select sum(f2) from t1,t2;
7 # Author : Jitendra Lenka
9 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
13 REL_PATH
=`pwd`/sql
/Aggregate
16 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -s $REL_PATH/nulltest1.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -s $REL_PATH/projfield.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
29 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql