问如何查询具有多到多关系的sql server中的2个表以确定差异

EN

select * /* change to whatever you need */
from
    (
        select *, row_number() over (partition by "code#" order by "something") as rn
        from tableA
    ) as a
        full outer join /* sounds like maybe left outer join will work too */
    (
        select *, row_number() over (partition by "id#" order by "date" desc) as rn
        from tableB
    ) as b
        on b."id#" = a."code#" and b.rn = a.rn

select tableA.*
     , tableB.*
  from tableA
left join tableB
       on tableB.PrimaryKey = tableA.PrimaryKey

select table1.*, table2.* 
  from table1 
  full outer join table2  
    on table1.Code# = table2.id#