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

Reply via email to