HI,
TRY LIKE THIS
DECLARE @TEMPTB TABLE(
ID INT IDENTITY(1,1)
,BRAND VARCHAR(50)
,OS VARCHAR(15)
,NETWORK VARCHAR(20)
)
INSERT INTO @TEMPTB
(BRAND,OS,NETWORK )
SELECT 'NOKIA','WINDOWS','2G'
UNION ALL
SELECT 'SAMSUNG','WINDOWS','2G'
UNION ALL
SELECT 'SAMSUNG','ANROID','3G'
UNION ALL
SELECT 'HTC','WINDOWS','3G'
UNION ALL
SELECT 'NOKIA','ANROID','2G'
SELECT * FROM @TEMPTB
SELECT * FROM @TEMPTB WHERE OS ='WINDOWS' AND (BRAND = 'NOKIA' OR BRAND='SAMSUNG' OR BRAND='HTC') AND (NETWORK='2G' OR NETWORK = '3G')