I was going thru the old unanswered thread, if still u r looking for a soultion try this

select table-1
set relation to custo-id into table-1, ;
custo-id into table-2, ;
custo-id into table-3, ;
custo-id into table-4, ;
custo-id into table-5

copy to New_Table fileds Table-1.custo-id,Table-1.Name, Table-1.Address,
Table-2. Phone, Table-2. po-box,Table-3. salary,> Table-3.score,Table-4.Quenty,Table-4.Language,Table-5.post ,Table-5. result

Jijo

> Hello again
> I got a new prob now. I have 5 table and every table has 3 fields. Every table has One common field.
> Now i want to join those table with every fields.Like
>
>
> Table-1
> custo-id Name Address
>
> Table-2
> custo-id Phone po-box
>
> Table-3
> custo-id salary score
>
>
> Table-4
> custo-id Quenty Language
>
> Table-5
> custo-id post result
>
>
> Now i want a result in a new table like this
>
>
> New_Table
>
> custo-id Name Address Phone po-box salary score Quenty Language post result
>
>


Jijo David