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

Query of a query 1

Status
Not open for further replies.
Michael57

Michael57

Technical User
Nov 15, 2005
131
CA
I have created to queries and from two diffent databases and saved them. SQL saves them in the project folder. How can I create a query that uses the results of the two queries?
 
Sort by date Sort by votes
You need to put your 'inside query' in parentheses:

Code: 
select test.[Index]
from
(--missing this, also need to add closing paren
SELECT

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
298
Andrzejek
Andrzejek
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
255
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
180
grnzbra
grnzbra
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
155
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
421
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top