> > SELECT > CallsList.NUMBER,ContactList.LAST_NAME,CallsList.DATE_AND_TIME,CallsList.READ_STATUS,LineSettingsList.LINE_NAME,CallsList.LINE_ID,CallsList.NUM_OF_CALLS > FROM CallsList WHERE NUMBER<='31'AND CALL_TYPE=0 COLLATE NOCASE LEFT JOIN > ContactList ON CallsList.NUMBER=ContactList.CONTACT_NUM_1 LEFT JOIN > LineSettingsList ON CallsList.LINE_ID=LineSettingsList.LINE_ID ORDER BY > NUMBER COLLATE NOCASE DESC; > > > Error: near "LEFT": syntax error
Seems like you need to put the WHERE clause after the JOIN clause. Try this: SELECT CallsList.NUMBER,ContactList.LAST_NAME,CallsList.DATE_AND_TIME,CallsList.READ_STATUS,LineSettingsList.LINE_NAME,CallsList.LINE_ID,CallsList.NUM_OF_CALLS FROM CallsList LEFT JOIN ContactList ON CallsList.NUMBER=ContactList.CONTACT_NUM_1 LEFT JOIN LineSettingsList ON CallsList.LINE_ID=LineSettingsList.LINE_ID WHERE NUMBER<='31'AND CALL_TYPE=0 COLLATE NOCASE ORDER BY NUMBER COLLATE NOCASE DESC; Regards Vitali _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
