create cursor gun1 ( pn i, opt1 c(5), opt2 c(5), opt3 c(5), opt4 c(5), opt5 c(5), opt6 c(5), opt7 c(5), opt8 c(5) )
create cursor gun2 ( pn i, opt1 c(5), opt2 c(5), opt3 c(5), opt4 c(5), opt5 c(5), opt6 c(5), opt7 c(5), opt8 c(5) )

for i = 1 to 100
   lcStr = padl( i, 5 )
   insert into gun1 values ( i, lcStr, lcStr, lcStr, lcStr, lcStr, lcStr, lcStr, lcStr )
   insert into gun2 values ( i, lcStr, lcStr, lcStr, lcStr, lcStr, lcStr, lcStr, lcStr )
endfor

select * ;
   from gun1 ;
   left join gun2 on ;
      gun1.pn = gun2.pn and ;
      gun1.opt1 = gun2.opt1 and ;
      gun1.opt2 = gun2.opt2 and ;
      gun1.opt3 = gun2.opt3 and ;
      gun1.opt4 = gun2.opt4 and ;
      gun1.opt5 = gun2.opt5 and ;
      gun1.opt6 = gun2.opt6 and ;
      gun1.opt7 = gun2.opt7 and ;
      gun1.opt8 = gun2.opt8