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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

search across several tables

Status
Not open for further replies.
guardianangel

guardianangel

Technical User
Mar 15, 2001
1
DE
I am loocking for a possibility to create a search across several tables without joining them in Access...
does anybody has a solution?
 
Sort by date Sort by votes
Uhm..maybe I don't understand well, you can't join it directly on the SQL statement of the search?
"SELECT .... FROM .... INNER JOIN .... WHERE ...." Stevie B. Gibson
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ceilicat
  • Locked
  • Question
Query of Queries Union Not Totaling Across Fields
Replies
2
Views
431
OneTrickPony
OneTrickPony
swansong77
  • Locked
  • Question
Output query and alert if there is a duplicate between 2 tables
Replies
3
Views
333
r937
r937
Mfho1
  • Locked
  • Question
Implementing A Search Using Verity via the Administrator (CF Version 7)
Replies
0
Views
203
Mfho1
Mfho1
Evil8
  • Locked
  • Question
Display data down and across in 4 columns 1
Replies
4
Views
322
vacunita
vacunita
Pugman
  • Locked
  • Question
SQL query on 3 tables works, 5 tables doesn't work
Replies
8
Views
448
Pugman
Pugman

Part and Inventory Search

Sponsor

Back
Top