• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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