*   *ID* N71JOIN1 DBCMD    changed on 1992-09-28-13.27.07 by ADMIN     *
file CONNECT ( KERN TEST !
create table t1 ( t1c1 char(251),
                  t1c2 char(250),
                  t1c3 char(250),
                  t1c4 char(249),
                  t1c5 char(151),
                  t1c6 char(150),
                  t1c7 char(100),
                  t1c8 char( 99),
                  t1b1 char(191),
                  t1b2 char(191),
                  t1b3 char(191),
                  t1b4 char(192) ) !
create table t2 ( t2c1 char(251),
                  t2c2 char(250),
                  t2c3 char(250),
                  t2c4 char(249),
                  t2c5 char(151),
                  t2c6 char(150),
                  t2c7 char(100),
                  t2c8 char( 99),
                  t2b1 char(191),
                  t2b2 char(191),
                  t2b3 char(191),
                  t2b4 char(192) ) !
create table t3 ( t3c1 char(251),
                  t3c2 char(250),
                  t3c3 char(250),
                  t3c4 char(249),
                  t3c5 char(151),
                  t3c6 char(150),
                  t3c7 char(100),
                  t3c8 char( 99),
                  t3b1 char(191),
                  t3b2 char(191),
                  t3b3 char(191),
                  t3b4 char(192) ) !
create table t4 ( t4c1 char(251),
                  t4c2 char(250),
                  t4c3 char(250),
                  t4c4 char(249),
                  t4c5 char(151),
                  t4c6 char(150),
                  t4c7 char(100),
                  t4c8 char( 99),
                  t3b1 char(191),
                  t3b2 char(191),
                  t3b3 char(191),
                  t3b4 char(192) ) !
select t1c3, t2c4 from t1,t2 where t1c1 = t2c1 
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
select t1c3, t2c4 from t1,t2 where t1c1 < t2c1  
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
select t1c3, t2c4 from t1,t2 where t1c2 = t2c2  
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
select t1c3, t2c4 from t1,t2 where t1c5 = t2c5 and t1c7 = t2c7  
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
select t1c3, t2c4 from t1,t2 where t1c6 = t2c6 and t1c7 = t2c7  
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
select t1c3, t2c4 from t1,t2 where t1c6 = t2c6 and t1c8 = t2c8 !
select t1c1 from t1,t2,t3 where t1c2 = t2c2  
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
select t1c1 from t1,t2,t3 where t1c4 = t2c4  
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
select t1c1 from t1,t2,t3 where t1c4 = t2c4 and t1c7 = t2c7  
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
select t1c1 from t1,t2,t3,t4 where t1c4 = t2c4 and t3c4 = t4c4  
 and t1b1=t2b1 and t1b2=t2b2 and t1b3=t2b3 and t1b4=t2b4 !
rollback work release !
