Hi, this seems like correct SQL to me. SQLite should execute it. Doesn't it work?
Martin Am 08.08.2011 07:50, schrieb William Canfield: > Hi, > I am having trouble writing a select statement. What I want to do is this: > > SELECT * FROM customers WHERE NOT EXISTS (SELECT * FROM orders WHERE > customers.id = orders.cust_id); > > Is this possible at all in Sqlite? > > regards > W. Canfield > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users