#
# Test of OGR SQL JOIN support via MapServer.  
#
# A joined field is used for the EXPRESSION used to classify the returned 
# polygons.
#   
# REQUIRES: INPUT=OGR OUTPUT=PNG INPUT=SDE
#
MAP

STATUS ON
#EXTENT 478300 4762880 481650 4765610
EXTENT 1731113.786242 660217.823431 1731605.958117 661097.125515
#EXTENT 1283364.000001 457670.968990 1330430.374999 495313.843989

SIZE 400 300

IMAGETYPE png

DEBUG ON

LAYER
  NAME shppoly
  TYPE polygon
  CONNECTIONTYPE SDE
  CONNECTION "smoke.hobu.net,5151,sde,sde,osgeo"
  DATA "SDE.FACILITIES_VIEW,SHAPE,SDE.DEFAULT"
  STATUS default
  DEBUG 3
  #CLASSITEM "SDE.JOINTESTTABLE.VAL"
  CLASS
    NAME "selected"
    COLOR 0 0 255
    OUTLINECOLOR 255 0 0
   # EXPRESSION "val1"
  END
  CLASS
    NAME "normal"
    COLOR 0 255 0
    OUTLINECOLOR 255 0 0
  END
END

END