intersect problem!!

[Xpertboy]

i am trying to execute following code in asp

var strSQL1="select Model from Phones where Brand='"+ brand +"'";
var strSQL2="select Model from Phones where Model='"+ model +"'";
var strSQL3="select Model from Phones where Camera='"+ camera +"'";

var strSQL=strSQL1+" intersect "+ strSQL2+" intersect "+strSQL3
conn.Execute(strSQL);

but its giving error in executing query... basically i want intersect of 2 or more features using INTERSECT .. how should i go about INTERSECT OPERATION?

[scripto]

try this

var strSQL1="select Model from Phones as p1 where Brand='"+ brand +"'";
var strSQL2="select Model from Phones as p2 where Model='"+ model +"'";
var strSQL3="select Model from Phones as p3 where Camera='"+ camera +"'";