Hi All, I am facing syntax error on Left join with my sqllite setup. The schema and query are given below with error
CREATE TABLE CallsList ( ENTRY_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,NUMBER TEXT NOT NULL,DATE_AND_TIME INTEGER NOT NULL,LINE_ID INTEGER NOT NULL,NUM_OF_CALLS INTEGER,READ_STATUS CHAR,CALL_TYPE CHAR NOT NULL ); CREATE TABLE ContactList ( ENTRY_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,LAST_NAME TEXT,FIRST_NAME TEXT,CONTACT_NUM_1 TEXT NOT NULL,CONTACT_NUM_1_TYPE CHAR NOT NULL,CONTACT_NUM_1_DEFAULT CHAR NOT NULL,CONTACT_NUM_1_OWN CHAR NOT NULL,CONTACT_NUM_2 TEXT,CONTACT_NUM_2_TYPE CHAR,CONTACT_NUM_2_DEFAULT CHAR,CONTACT_NUM_2_OWN CHAR,ASSOCIATED_MELODY INTEGER,LINE_ID INTEGER ); CREATE TABLE LineSettingsList ( ENTRY_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,LINE_NAME TEXT,LINE_ID INTEGER NOT NULL,ATTACHED_HANDSETS INTEGER NOT NULL,DIALING_PREFIX TEXT,FP_MELODY INTEGER,FP_VOLUME INTEGER,BLOCKED_NUMBER TEXT,MULTIPLE_CALLS_MODE CHAR NOT NULL,INTRUSION_CALL CHAR,PERMANENT_CLIR CHAR,PERMANENT_CLIR_ACTIVATION_CODE TEXT,PERMANENT_CLIR_DEACTIVATION_CODE TEXT,CALL_FWD_UNCOND CHAR,CALL_FWD_UNCOND_ACTIVATION_CODE TEXT,CALL_FWD_UNCOND_DEACTIVATION_CODE TEXT,CALL_FWD_UNCOND_TARGET_NUMBER TEXT,CALL_FWD_NO_ANSWER CHAR,CALL_FWD_NO_ANSWER_ACTIVATION_CODE TEXT,CALL_FWD_NO_ANSWER_DEACTIVATION_CODE TEXT,CALL_FWD_NO_ANSWER_TARGET_NUMBER TEXT,CALL_FWD_NO_ANSWER_TIMEOUT CHAR,CALL_FWD_BUSY CHAR,CALL_FWD_BUSY_ACTIVATION_CODE TEXT,CALL_FWD_BUSY_DEACTIVATION_CODE TEXT,CALL_FWD_BUSY_TARGET_NUMBER TEXT ); 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 I am aware of sql syntaxes and not an expert DBA. please let me where I am going wrong in framing the syntax. Thanks Suresh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
