imbedded sql sytax question

Hi All,

 

I have a select statement as follows:

 

Select  * from File1 where phonenumber = '2015551212';

 

This works great, but now I have another file (File2 or argument sake) that
contains additional phone numbers. File1 and File2 can be joined by
clientnumber.

 

My code is as follows

 

 

exec sql set option datfmt=*usa;   

exec sql prepare s2 from :dynstm;  

exec sql declare c2 cursor for s2; 

exec sql open c2;

exec sql fetch c2 into :thefileds;

dow sqlcod = 0;

 

 

Is there a way for me to join these 2 files together (File1 & File2) and
still be able to use the "thefileds" on my fetch.

 

 

Hope this makes some kind of sense.

 

Tim