Access Query Problem

Posted on 2009-12-16
Last Modified: 2012-05-08

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

Question by:NigelRocks
    LVL 77

    Expert Comment

    There is no such concept in Access sql.
    You have to express your joins using the names (or aliases for) of the original tables.

    LVL 13

    Accepted Solution


    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

    LVL 1

    Author Closing Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now