[sqlite] brain failed: help needed

2012-03-17 Thread RhinosoRoss
Hi everyone, Sorry to be a pest, but I'm drowning in manual pages and clearly missing something simple. I don't think I'm going to progress without some help. I noticed at work that they were using excel to store serial numbers of devices sold in orders... Should be a database! So I knocked one

Re: [sqlite] brain failed: help needed

2012-03-17 Thread Puneet Kishor
You need LEFT JOIN. Also, keep in mind that no operator other than IS NULL or IS NOT NULL works on NULL. On Mar 17, 2012, at 9:06 AM, RhinosoRoss bosss...@hotmail.com wrote: Hi everyone, Sorry to be a pest, but I'm drowning in manual pages and clearly missing something simple. I don't

Re: [sqlite] brain failed: help needed

2012-03-17 Thread Richard Hipp
On Sat, Mar 17, 2012 at 10:06 AM, RhinosoRoss bosss...@hotmail.com wrote: Hi everyone, Sorry to be a pest, but I'm drowning in manual pages and clearly missing something simple. I don't think I'm going to progress without some help. I noticed at work that they were using excel to store