<div>Hi All,</div> <div> I tried to join the SDF faeture source spatial data with the SQL Server 2005 Views(non spatial data) ,I manage to get the new joined feature source and get the attributes in the property pane but i stuck in the Search criteria and when i tried to search the joined feature class using the filter like -</div> <div> </div> <div>$filter ="LU_STATUS = '" . $status ."'"." and " . "PD_GROUP= '".$group."'"." and " . "SHAREHOLDE= '".$share."'"." or " . "PROMOTION= '".$plan."'";</div> <div> </div><FONT face=CourierNewPSMT size=1> <div align=left>$queryOptions = new MgFeatureQueryOptions();</div> <div align=left>$queryOptions->SetFilter($filter);</div> <div align=left> </div> <div align=left><FONT size=3>I unable to get any values and it use to give no search found.Can anybody help me regarding this issue and where i can get some detail for working with SQL
commands on the feature source ,i tried in the mapagent some basic sql commands but it use to give error and i cannot find the way to go with them.</FONT></div> <div align=left> </div> <div align=left>Thanks</div> <div align=left>Max</div> <div></FONT><BR><BR> </div><p> 
<hr size=1>Yahoo! oneSearch: Finally, <a href="http://us.rd.yahoo.com/evt=48252/*http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC"> mobile search
that gives answers</a>, not web links.