Calculation Field help
So I have two tables link together in essentially a one to many relationship. I am trying to populate a calculation field based which should, when based on a "where clause", would return one record. My Sql would be 'Select answer from (innerjoin code) where QuestionID = "1"' I have tried if(Answer::QID = 1; Answer::Response; "Unknown") but nothing shows up. Can anybody give me a hand here?