如何在SQL2000数据库把两张表关联

select isnull(a.id,b.id) as id,isnull(a.日期,b.日期) as 日期, isnull(a.金额,0) as 表1金额, isnull(b.金额,0) as 表2金额 from A full join B on a.id=b.id and a.日期=b.日期