General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Ray,
Am I missing the point (?) but why don't you use your original code but make the first query select into a TABLE in what ever directory/network pc that you want ? ie:-
select 'MAIL',fm_addr1,fm_addr2,fm_city,fm_state,fm_zip;
from family;
where family_id=fid;
into table x1
select 'SITE',fp_addr1,fp_addr2,fp_city,fp_state,fp_zip;
from family;
where family_id=fid;
into cursor x2
select x1
append from x2
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only