dBforums - View Single Post

tcliam · #7 (**permalink**) 01-26-10, 16:56

The error is from this piece of code.

Code:

  INNER JOIN (
  
    SELECT MemberID,  
           tblProposal.ProposalID,
           fn_GetPropData_Integer('PILevelOfCover', tblProposal.ProposalID::int) AS PreviousOption
    FROM tblSchemeProjectMember 

    INNER JOIN tblProposal ON tblProposal.ProposalID = tblSchemeProjectMember.ProposalID
    WHERE tblSchemeProjectMember.SchemeProjectID = RenewFromSchemeProjID
     AND tblProposal.ProposalSubmitted IS NOT NULL  
	 
  ) PreviousProject ON tblSchemeProjectMember.MemberID = PreviousProject.MemberID

It seems to crash on

Code:

 PreviousProject ON tblSchemeProjectMember.MemberID = PreviousProject.MemberID

And this is the error message

Code:

ERROR:  column previousproject.memberid does not exist
LINE 1: ...viousProject ON tblSchemeProjectMember.MemberID = PreviousPr...

Thanks
Liam