Re: [sqlite] Re: Re: Select with left outer join - Am I going mad ? Second edition

I don't know how sqlite handles parenthesis in joins. the first query is not recognized by the syntax (mpm.MediumID undefined). The second one just returns ids with name and value being empty. However I only use 3.3.4, is there any documentation on this ? Igor Tandetnik wrote: Alex

Re: [sqlite] Re: Select with left outer join - Am I going mad ? Second edition

I tried this one of course, and it doesn't work, it could be a bug. It returns every property for every medium (not just 'myprops') Igor Tandetnik wrote: Alexandre Guion <[EMAIL PROTECTED]> wrote: SELECT m.MediumID AS id, IFNULL(pn.Text, '') AS name, IFNULL(p

[sqlite] Select with left outer join - Am I going mad ? Second edition

Hey all, I'm getting crazy on a problem with left join in SQLite. Either I didn't understand something, or there's a bug somewhere. Here's a sample of my DB CREATE TABLE Media ( MediumId INTEGER PRIMARY KEY, ... ) CREATE TABLE MediumPropMap ( MediumId INTEGER NOT NULL, (foreign key from Media)

Re: [sqlite] IF EXISTS when using DROP TABLE

You can use the PRAGMA query to test if a table exists or not. "PRAGMA table_info(`tablename`)" -- Alex Guion Software Engineer OrbNetworks, Inc. www.orb.com [EMAIL PROTECTED] wrote: Thank you. My version does not. I had used one of the archives to search for this issue, but the thread I