Thanks for the reply but table A has a range (with 2 columns Start and End. Example 1 50), your query would work if it had just items.

Any other thoughts ???


>>Hello all
>>
>>I have 2 tables,a and b and table a has a range of item numbers and table b has the actual items,how can i write a sql to pull all the missing items from table b.
>>
>>Example
>>Table A
>>------------------
>>ItemBegin ItemEnd
>>1 50
>>
>>Table B
>>
>>Items
>>1
>>2
>>7
>>9
>>10
>>
>>I want the query to pull missing records as
>>3-6
>>8-8
>>11-50
>>
>>Is it possible without writing a procedure ??
>>
>>Thanks
>
>

>SELECT item FROM table_a WHERE item NOT IN (SELECT item FROM table_b)
>