combind SQl statement

[Jpernice]

Hello

Can some please help me combind these two SQL


SELECT Products.type
FROM Products
WHERE Products.type Like 'C';

and

SELECT ItemNumber+1 AS BeginSeries
FROM [SELECT DISTINCT ItemNumber FROM Products]. AS T
WHERE (((Exists (SELECT * FROM Products T1
WHERE T1.ItemNumber = T.ItemNumber + 1))=False) AND ((T.ItemNumber)<(SELECT MAX(ItemNumber) FROM Products)));


Thanks

 

[apr pillai]

Try this:

SELECT Products.type,

(SELECT ItemNumber+1 
FROM [SELECT DISTINCT ItemNumber FROM Products]. AS T
WHERE (((Exists (SELECT * FROM Products T1
WHERE T1.ItemNumber = T.ItemNumber + 1))=False) AND ((T.ItemNumber)<(SELECT MAX(ItemNumber) FROM Products)))) AS BeginSeries

FROM Products
WHERE Products.type Like 'C';