Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: What do you call it when...

    I'm looking at a query. The query contains two tables. The first table is an actual table but the second table is defined as a seperate query. The separate query is a query on the first table which lists an education id number but is not a key in the table. The two tables in the query in question are joined at this number.

    What would this type of query be called. I'm trying to find more info on it but I'm not sure if it has a tpye I can do that with.

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: What do you call it when...

    When you write a query that uses the same table it is called a self-join query.
    In abundance of water only the fool is thirsty. Bob Marley.

  3. #3
    Join Date
    Feb 2004
    Posts
    5
    Thanks. I thought thats what it might be but was only thinking of it joining a file not a query. After a little playing around with it I figured out what they were trying to do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •