>I have two tabkes which differ by a single field. Table one resides on a server and I want to copy its data to a table which resides on my PC. All the data is the same except for the extra field. The table is linked to a 2sd table which should have the same number of key field a but 1 to n values of key field b. I want to also copy the linked table to my PC. Once two tables are on my PC I want to use the 2sd table to create a list of key field a and the assocated value of the field in table one (one with no values).
>
>What is the best way to do this?
Claude,
I think nobody understood your question yet, I didn't either. Would you rephrase it with sampling.
Shooting in dark it sounds you could do something like:
select *, 0*0x7FFFFFFF as extraField from myTable
Cetin