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 ProjectData >> WHERE (ProjectId = @Id)) derivedtbl_1 >> >> On ExcelMapValue.InputId = derivedtbl_1.InputId > > Try this: > > Select * From ExcelMapValue e left join ProjectData p > on (e.InputId = p.InputId and p.ProjectId = @Id); > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Left-Join-tp20725943p20735463.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
