Re: [sqlite] Left Join

2008-11-28 Thread Tommy Anderson
It's working, Thank you! Igor Tandetnik wrote: > > "Tommy Anderson" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> Select * From ExcelMapValue >> >> OUTER JOIN (SELECT ProjectId, InputId, DataValue, Formula >> FROM

[sqlite] Left Join

2008-11-27 Thread Tommy Anderson
Hi, I have a left join problem with SQLite. this Select SELECT ProjectId, InputId, DataValue, Formula FROM ProjectData WHERE (ProjectId = @Id) contains almost 15 000 rows. this Table ExcelMapValue contains almost 5 000 rows. and contains these columns InputId, sheetCode,