Query two SQL tables from data mapper.

Answered

Randall Krass

• January 11, 2017 16:38

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?

0

• 

  Randall Krass

  • January 11, 2017 18:56
  • Edited

  OK. I figured this one out. Was over thinking it. A simple addition to the SQL statement was all that was needed.

  0

Please sign in to leave a comment.