469,348 Members | 1,384 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,348 developers. It's quick & easy.

intersect problem!!

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?
May 7 '07 #1
1 1336
scripto
143 100+
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 +"'";
May 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Nick | last post: by
1 post views Thread by shark | last post: by
3 posts views Thread by prathamesh.deshpande | last post: by
1 post views Thread by =?Utf-8?B?TWl0Y2hX?= | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.