>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?

I answered your question in other thread Message #1255191