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

    Join Date
    Feb 2005
    Rep Power

    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
    The Great Land
    Rep Power
    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.

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