<div>Bill thanks a lot for your reply. I did change the left join to inner join. But the problem I am having is while trying to connect two tables with one to many relationship. What mapeserver is doing is this,</div>
<div> </div>
<div>Table 1 ( spatial table ) Table 2 ( postgre table)</div>
<div> </div>
<div>These are unique numbers Table to has multiple values for the same unique number in table 1.</div>
<div>101 101 John</div>
<div>102 101 Tom</div>
<div>103 102 Mark</div>
<div> </div>
<div> </div>
<div>If I run the query my out put looks like this</div>
<div> </div>
<div>101 John</div>
<div>101 <strong>John</strong></div>
<div>102 Mark</div>
<div> </div>
<div>Mapserver is not returning the second value from table 2 instead its returning the same thing again. I am sorry if I have any basic things wrong, I am really new to this and any bit of info would help thanks.</div>
<div> </div>
<div>Kris</div>