Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: jijo david
  Where is jijo david?
 jijo david
 To: munir hossain
  Where is munir hossain?
 munir hossain
Subject: RE: Join few table with every fields in Query
Thread ID: 15953 Message ID: 16437 # Views: 0 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Saturday, October 19, 2002 2:55:31 PM         

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


> 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


Join few table with every fields in Query Posted by munir hossain @ 10/4/2002 9:56:13 PM
RE: Join few table with every fields in Query Posted by jijo david @ 10/19/2002 2:55:31 PM