[FONT=Courier New][SIZE=2][COLOR=#0000ff]SET DEFAULT TO [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]"D:\Data"
[/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]Select [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]1
[/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]Use [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]dbf0
[/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]Select [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]2
[/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]Use [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]dbf1
[/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]SELECT [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]dbf0.*,dbf1.* [/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]FROM [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]dbf0 [/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]LEFT JOIN [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]dbf1 [/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]ON [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]dbf0.Soct= Dbf1.soct [/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]TO [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]data1
[/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]COPY TO [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]dbf2.[/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]dbf
Export to [/COLOR][/SIZE][/FONT][FONT=Courier New][SIZE=2]Dbf2.[/SIZE][/FONT][FONT=Courier New][SIZE=2][COLOR=#0000ff]xls type XL5
CLOSE DATABASES
SET DEFAULT TO
return
[/COLOR][/SIZE][/FONT]