Query two SQL tables from data mapper.

I’ve been using this query in the data mapper to get information from a single table: ” PreparedQuery {'Select JobNumber From OrderHeader Where PONumber=? And ProofComments=?' ,$GT_E32_DB ,'true' ,( concat($Input_GT_WebService_SubmitOrder/Root/order/id ,'Parent' )  )}”. For a different situation, is there a way to add a SQL JOIN statement to the query to get field data from a second table?

Another option might be passing a parameter to a stored procedure to return the desired field data. How might I go about this?

1 comment

Please sign in to leave a comment.