"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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users