Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how do i connect three tables and run a query

Status
Not open for further replies.
jododge

jododge

MIS
Joined
Oct 4, 2001
Messages
1
Location
US
I need all of table one
tt#, ncn#, soc, name last, name first, address, city, zip
I need 4 fields of table two (one is included in table one)
ncn#, art1, art2, art3,
I need some fields of table three (one is included in table one)
tt#, mes1, mes2, mes3, mes4

 
Sort by date Sort by votes
Assuming you mean in objectPAL not interactive:

q = query

table1 | tt# | ncn# |
check |_join1 | _join2 |

table2 |ncn# | art1 | art2 | art3 |
| _join2 |check | check | check |

table3 |tt# | mes1 | mes2 | mes3 | mes4 |
| _join1 | check | check | check | check |

endquery

HTH,
Richie
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AyoubEddakkaoui
  • Locked
  • Helpful tip Helpful tip
Paradox 11: How to Fix Opening Help file (Help topics)
Replies
0
Views
1K
AyoubEddakkaoui
AyoubEddakkaoui
caitlind
  • Locked
  • Question Question
It's hot, cool and stylish summer outfits
Replies
0
Views
688
caitlind
caitlind
PhilipTdotcom
  • Locked
  • Question Question
Paradox 11 Table Restructure: Lookup Tables tab crashes Paradox
Replies
2
Views
679
anniekl
anniekl
trsiskotr
  • Locked
  • Question Question
Paradox 9 on winxp all of a sudden printing all worksheets/tables from 2007
Replies
3
Views
526
simd01
simd01
ebtrr
  • Locked
  • Question Question
Query last modify date/time of table row
Replies
1
Views
497
rum63
rum63

Part and Inventory Search

Sponsor

Back
Top