>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)