<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
That depends on the provider. Some providers supports full SQL syntax.<br>
<br>
I can't see how you can join tables with a filter, as that is the
equvalent of the SQL WHERE construct.<br>
You can try to setup a Join on the featuresource, but I have had
limited success with joins.<br>
<pre class="moz-signature" cols="72">Regards, Kenneth, GEOGRAF A/S
</pre>
<br>
<br>
ary sucaya skrev:
<blockquote cite="mid:504088.61622.qm@web58606.mail.re3.yahoo.com"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">
<div>Hello,</div>
<div> </div>
<div>I was wondering if i can put a complex sql statement at 'Filter
applied to data' textbox on Layer Editor. I need to show some data from
my postgis table and sql to select this data involving 2 or more table.</div>
<div> </div>
<div> </div>
<div>Regs,</div>
<div> </div>
<div>ary sucaya</div>
</div>
<br>
<hr size="1">Never miss a thing. <a moz-do-not-send="true"
href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs">
Make Yahoo your homepage.</a>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
</body>
</html>