Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jun 2012
    Location
    Delhi
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Join Query solution for multiple table check.

    hi,
    I have six tables each having a column field (order_no), now i want to match that something like this.

    1- select order_no from table 1 where order_no != with order_no present in all other six tables.

    Can any one suggest which join query or which query i should use to achieve this?
    thanks

  • #2
    New Coder
    Join Date
    Jun 2011
    Posts
    25
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Its probably not the best way to do it but could you not select all from table 1 and then run your checks on the other tables using IF statements? Might be a little crude but I've never seen a join of more then 2 tables myself.

  • #3
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,877
    Thanks
    2
    Thanked 164 Times in 159 Posts
    Alex,

    Joining more than 2 tables is common. I have queries that join 5 and 6 tables.


  •  

    Tags for this Thread

    Posting Permissions

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