Re: [sqlite] exists clause in select

On Mon, 08 Aug 2011 07:50:21 +0200, William Canfield wrote: >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

Re: [sqlite] exists clause in select

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 >

[sqlite] exists clause in select

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 ___