<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18702"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Hi, </DIV>
<DIV>I'm trying to draw a 'shape' and a 'related shape'. </DIV>
<DIV>These shapes are both from the same View in Oracle (For eg. asset_shape, rel_shape, asset_ID, rel_ID). </DIV>
<DIV> </DIV>
<DIV>Can I call for two geometry shapes somehow?</DIV>
<DIV> </DIV>
<DIV>My current 'data' call in my mapfile is:</DIV>
<DIV> </DIV>
<DIV>DATA "REL_SHAPE FROM (SELECT ASSET_ID, REL_ID, ASSET_SHAPE, REL_SHAPE FROM DB.VIEW) USING UNIQUE REL_ID"</DIV>
<DIV> </DIV>
<DIV>I want both rel_shape and asset_shape to be drawn on the map. </DIV>
<DIV> </DIV>
<DIV>Currently, I can only see the related shape (obviously). </DIV>
<DIV> </DIV>
<DIV>Thanks, </DIV>
<DIV>Jess</DIV>
<DIV> </DIV><BR>
<p>
<font face="Arial" size="1">---------------------------------------------------------------------------------------------------------------------------------------------
</font><br>
</p>
<p>
<font face="Arial" size="1">This transmission is intended solely for the
person or organisation to whom it is addressed. </font>
</p>
<p>
<font face="Arial" size="1">It is confidential and may contain legally
privileged information. </font>
</p>
<p>
<font face="Arial" size="1">If you have received this transmission in
error, you may not use, copy or distribute it. </font>
</p>
<p>
<font face="Arial" size="1">Please advise us by return e-mail or by
phoning 61 3 6235 8333 and immediately delete the transmission in its
entirety. </font>
</p>
<p>
<font face="Arial" size="1">We will meet your reasonable expenses of
notifying us. </font>
</p>
<p>
<font face="Arial" size="1">Despite our use of anti-virus software,
Forestry Tasmania cannot guarantee that this transmission is virus-free. </font>
</p>
<p>
<font face="Arial" size="1">--------------------------------------------------------------------------------------------------------------------------------------------
</font>
</p>
</BODY></HTML>