> "SELECT > VA_MK_YEAR,VA_MK_DESCRIP,VO_VIN_NO,VO_MODEL,VO_BODY,VO_DESCRIPTION" + \ > "FROM D014800 LEFT OUTER JOIN D014900 ON (VA_MK_NUMBER_VER = > VO_MAKE_NO) AND (VA_MK_YEAR = VO_YEAR)" + \ > "WHERE (((VA_MK_YEAR)=?) AND ((VA_MK_DESCRIP)=?) AND > ((VO_MODEL)=?))"
Doesn't look like you have a space between "VO_DESCRIPTION" and "FROM" SQL statements are a good place to use Python's triple-quote feature: sql = """\ SELECT VA_MK_YEAR, VA_MK_DESCRIP, VO_VIN_NO, VO_MODEL, VO_BODY, VO_DESCRIPTION FROM D014800 LEFT OUTER JOIN D014900 ON ( VA_MK_NUMBER_VER = VO_MAKE_NO AND VA_MK_YEAR = VO_YEAR ) WHERE VA_MK_YEAR = ? AND VA_MK_DESCRIP = ? AND VO_MODEL = ? """ -- http://mail.python.org/mailman/listinfo/python-list