Post reply

full outer join on 3 tables

  • March 17, 2005 at 9:15 am

    #547579

    nicki ,

    I am sorry I wasn't explicit enough I put q in red and bold on my query and assumed it will make it apparent but I was wrong. Anyway I think you are on your way now!

    Good Luck


    * Noel

  • March 17, 2005 at 9:16 am

    #547582

    This works- this is great. Thank you so much... Now I also see that there was a letter q after that nested query too which i thought was some kind of face. This is perfect. I now have unique ids.

    Select dtAllPrids.comp_prid, a.*, b.*, c.*

    From

    (

      Select LV_PrID As comp_prid From tblCompLV_cross

      Union

      Select LN_PrID As comp_prid From tblCompLN_cross

      Union

      Select SR_PrID As comp_prid From tblCompSR_cross

    ) dtAllPrids

    Left Join tblCompLV_cross As a On ( ... )

    Left Join tblCompLN_cross As b On ( ... )

    Left Join tblCompSR_cross As c On ( ... )

  • March 17, 2005 at 10:43 am

    #547614

    Thanks for all your help and patience!

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply