>one table has address,name and vin_id
>
>for instance
>
>table a has 'Ronnie Sheppick' for name 'My Street' for address then vin_id is '1'
>
>table b has other random fields
>
>I need to create table c by taking selected fields from my table a and table b where the vin_id is the same does that make sense?
What version of VFP you use?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.