AnsweredAssumed Answered

I need help, I want to label a layer using SQL Query i.e a Primary and Foreign Key

Question asked by GISGURU_001 on Aug 31, 2012
Latest reply on Sep 7, 2012 by GISGURU_001
I want to label a layer using SQL Query i.e a Primary and Foreign Key, the primary key field is the OBJECTID in the polygon layer while the ParcelID is the Foreign Key field in the Line_Clip layer. Below is my script but it is not working;

import arcpy mxd = arcpy.mapping.MapDocument("Current") lyr = "Lines_Clip" lyr1 = "Parcels_Clip" field1 = "OBJECTID" field2 = "ParcelID" for lyr in arcpy.mapping.ListLayers(mxd):     if lyr.supports("LABELCLASSES"):         if lyr.showLabels:   where "ParcelID" = "OBJECTID"


What im i doing wrong?
Thanks

Outcomes