Guest User

Untitled

a guest
Nov 15th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. expression_2 = """SELECT F_ARODES.ARODES_INT_NUM, F_STOREY_SPECIES.SPECIES_CD, F_STOREY_SPECIES.SPECIES_AGE
  2. INTO fill_wydzielenia_2_temp
  3. FROM F_GROUP_CATEGORY INNER JOIN ((F_ARODES INNER JOIN F_SUBAREA ON F_ARODES.ARODES_INT_NUM = F_SUBAREA.ARODES_INT_NUM) INNER JOIN (F_AROD_STOREY INNER JOIN F_STOREY_SPECIES ON (F_AROD_STOREY.ARODES_INT_NUM = F_STOREY_SPECIES.ARODES_INT_NUM) AND (F_AROD_STOREY.STOREY_CD = F_STOREY_SPECIES.STOREY_CD)) ON F_SUBAREA.ARODES_INT_NUM = F_AROD_STOREY.ARODES_INT_NUM) ON F_GROUP_CATEGORY.AREA_TYPE_CD = F_SUBAREA.AREA_TYPE_CD
  4. WHERE (((F_ARODES.TEMP_ACT_ADRESS)=?) AND ((F_AROD_STOREY.STOREY_RANK_ORDER)=?) AND ((F_STOREY_SPECIES.SPECIES_RANK_ORDER)=?) AND ((F_GROUP_CATEGORY.SUPERGR_CAT_NAME)=?))"""
  5.  
  6. db_cursor.execute(expression_2, (True, 1, 1, u"grunty leΕ›ne zalesione"))
  7. db_cursor.commit()
Add Comment
Please, Sign In to add comment