Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combine 3 tables
Message
From
10/11/2000 04:20:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Combine 3 tables
Miscellaneous
Thread ID:
00440084
Message ID:
00440084
Views:
62
i would like to join 3 tables in one pass and would like to have some suggestions. examples of the tables are follows:-

table A
ID name
1 ABC
2 DEF
3 JKL
4 MNO
5 XYZ

table B
ID status
1 M
2 F

table C
ID skills
3 9
5 7

the resultant table to look like :-

ID name status skills
1 ABC M
2 DEF F
3 JKL 9
4 MNO
5 XYZ 7

many thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform