• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

Access Query Problem

Experts,

The query below will not let me form a derived table.  It doesn't like "As Childtable".  Why not?
SELECT Notes.Note_ID,Note_Categories.Note_Category_Description,Notes.Notes_Title,Notes.Notes_Description  
FROM Relationship r
INNER JOIN (Notes INNER JOIN Note_Categories ON Note_Categories.Note_Category_ID=Notes.Notes_Category)  As ChildTable 
ON r.ChildID=ChildTable.Note_ID

Open in new window

0
NigelRocks
Asked:
NigelRocks
1 Solution
 
peter57rCommented:
There is no such concept in Access sql.
You have to express your joins using the names (or aliases for) of the original tables.

0
 
sameer2010Commented:
Hi,

Use this...
SELECT Notes.Note_ID,Note_Categories.Note_Category_Description,Notes.Notes_Title,Notes.Notes_Description  
FROM Relationship r
INNER JOIN Notes 
	ON r.ChildID=Notes.Note_ID
INNER JOIN Note_Categories 
	ON Note_Categories.Note_Category_ID=Notes.Notes_Category  
;

Open in new window

0
 
NigelRocksAuthor Commented:
This suggestion was useful, but the issue was that I didn't have a SELECT statement at the beginning of my derived table.  Derived tables are of course allowed in Access SQL.  I've used them for ages.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now