Post reply

how to check a series within a series

  • May 28, 2008 at 12:25 pm

    #93478

    I have two tables

    Customers

    ------------------------------------------------------------------

    CustomerID FromFlatNo ToFlatNo

    1 11 16

    2 6 10

    2 13 18

    Flat_Booking

    ------------------------------------------------------------------

    CustomerID FromFlatNo ToFlatNo

    1 11 16

    2 1 5

    2 3 4

    I want to get all the flat numbers against customer 2 which are there in Customers Table, but not in

    Flat_Booking

    eg : customer 2 result is 1,2,3,4,5

  • May 29, 2008 at 2:22 am

    #821634

    What's wrong with the suggestions made here

    http://www.sqlservercentral.com/Forums/Topic507555-145-1.aspx#bm507909

    N 56°04'39.16"
    E 12°55'05.25"

Viewing 2 posts - 1 through 1 (of 1 total)

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