title: DB2 SQL HOW TO RETURN 1 ROW ON JOIN TABLE FROM INNER JOIN TABLE
body: <pre><code>SELECT GARAGE, MAKE
  FROM NEIGHBORHOOD_TABLE A
  JOIN VEHICLES_TABLE B ON B.MAKE = A.MAKE DISTINCT BY B.MAKE
  WHERE A.ZIPCODE = MY_ZIP_CODE
  ;
  </code></pre>
  <p>Now I want to return all the garages in my zip code with a FORD make. Now the Vehicles-Table can have multiple Models of FORD Makes on the join but I only want to return 1 row for FORD make not all the models FUSION, RANGER, F150....probably a bad example but the Idea is I want to return multiple rows from Table A that Match Table B however Table B may have multiple rows that match table A but I want only 1 row, sort of distinct by B.MAKE.</p>
  <p>This is a DB2 SQL database.
  Thanks if you can figure out what I am asking.</p>