Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Query question

Discussion in 'Information Technology' started by john, Jul 28, 2006.

Tags:
  1. john

    john
    Expand Collapse
    Guest

    I have table A which is linked 1xM to table B. I would like to pull out all
    table A's records that have no corresponding record in table B. How can I do
    this?
    thanks,
    john
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Use the query wizard to create an UnMatch Record Query, to display all the
    records in table A that has no corresponding records in table B

    --
    Good Luck
    BS"D


    "john" wrote:

    > I have table A which is linked 1xM to table B. I would like to pull out all
    > table A's records that have no corresponding record in table B. How can I do
    > this?
    > thanks,
    > john
    >
    >
    >
     

Share This Page