#1
  1. No Profile Picture
    Contributing User
    ASP Good Citizen (1000 - 1499 posts)

    Join Date
    Feb 2005
    Posts
    1,285
    Rep Power
    39

    Query with Append of 4th table


    Not sure how to approach this.

    I have a query that is joining 3 tables by a unique field.
    tbl_Location (locationID)
    tbl_Collections (ID)
    tbl_Gear (ID)

    There is a one to many from tbl_Location to tbl_Collections
    If tbl_Collections ID field exists in tbl_Location show me the locationID and all the tbl_Collections Records.

    This works fine BUT
    I have a 4th table that has Counts. This table is in the same format as tbl_Collections and also can be joined by ID field.

    What i want to do is add these records as results to the query above.

    SO if tbl_Collections had 345 records and the 4th table (once joined by ID) had 32 records I want the resulting table to have 377 records.
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,626
    Rep Power
    653
    That would require a UNION query, not a JOIN. However, doesn't really seem sensible to append aggregate data to raw data.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm

Similar Threads

  1. Append xls data into SQL table without .NET
    By garybrett in forum ASP Development
    Replies: 1
    Last Post: November 25th, 2009, 05:58 AM
  2. Append Current Record to another Table
    By Solitaire in forum Microsoft Access Help
    Replies: 4
    Last Post: October 30th, 2006, 09:16 AM
  3. Append query to different table
    By JPR in forum Microsoft Access Help
    Replies: 0
    Last Post: March 28th, 2006, 08:10 AM
  4. Append Query to table
    By bigbadbess24 in forum Microsoft Access Help
    Replies: 3
    Last Post: March 22nd, 2006, 02:50 PM
  5. output a form and append into table
    By G H-F in forum ASP Development
    Replies: 3
    Last Post: June 29th, 2004, 02:04 PM

IMN logo majestic logo threadwatch logo seochat tools logo