Looking for a command... 1

[kate]

I'm working in VFP 6.0. I'm trying to combine two foxpro tables into one. They both have a field that is same called sft_cd. I want to add the extra fields from one table to the other table, but I don't want to have to type in the info again. For example

table a:
sft_cd (N,2)
start_time (C,4)
end_time (C,4)

table b:
sft_cd (N,2)
split (L)
first (N,2)
second (N,2)

I want to combine these tables into table c

table c:
sft_cd (N,2)
start_time (C,4)
end_time (C,4)
split (L)
first (N,2)
second (N,2)

Is there a foxpro command that would do this, or will I have to write a short program. Writing the program is not a big deal, I'm just trying to cut some corners.

Thanks in advance. Please let me know if there are any questions.

 

[alvechurchdata]

You need to use an SQL statement. I've not tested this but it'll be a start:

Select a.sft_cd, a.start_time, a.end_time, b.split, b.first, b.second from a, b where a.sft_cd = b.sft_cd into table c

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[kate]

Thanks Geoff. I'll try that.

 

[mspratt]

Hi Kate,

Create a view that joins the tables. Use the view and COPY TO tableC.

Regards,

Mike