Since you didnt specify any condition for QA to execute and filter the result you want,it's retional to have such result.

The following is one of the queries can lead the result you want


select b.*,a.Claim,a.shiptype from tablea a,tableb b where Claim = 100 and Cost = 50 or Claim = 200 and cost = 100