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