Finding data differences between two queires

SELECT distinct c.sid_ident,c.fix_ident
   from corept.std_sid_leg as c
   INNER JOIN
   (
      SELECT sid_ident, transition_ident, max(sequence_num) seq, route_type
      FROM corept.std_sid_leg
      WHERE data_supplier='J' AND airport_ident='KBOS'
      GROUP BY sid_ident,transition_ident
   ) b ON c.sequence_num=b.seq
       and c.sid_ident = b.sid_ident
       and c.transition_ident = b.transition_ident
    WHERE c.data_supplier='J' and c.airport_ident='KBOS'
Query:2
SELECT
  name,
  trans
FROM skyplan_deploy.deploy_sids
ON d.name=c.sid_ident
WHERE apt = 'KBOS'
  AND name != trans