> insert into tb_appointment(GroupCalendarID, ObjectID, Subject) values( > ( > select ugc.GroupCalendarID > from TB_User_GroupCalendar ugc > join TB_User u on u.objectID = ugc.UserID > join TB_GroupCalendar gc on gc.ObjectID = ugc.GroupCalendarID > where calendarname='DEFAULT CALENDAR FOR ' || u.Username > ), > 'ZZzxzzxczxde', 'TEST SUBJECT') > >
Try it this way: insert into tb_appointment(GroupCalendarID, ObjectID, Subject) select ugc.GroupCalendarID, 'ZZzxzzxczxde', 'TEST SUBJECT' from TB_User_GroupCalendar ugc join TB_User u on u.objectID = ugc.UserID join TB_GroupCalendar gc on gc.ObjectID = ugc.GroupCalendarID where calendarname='DEFAULT CALENDAR FOR ' || u.Username _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users