left join NULL

[nahpets]

Hallo,

so sollte es gehen:

SQL-Code:

select
  a.menge as bestand,
  b.menge as reserviert,
  (IsNull(a.menge,0) - IsNull(b.menge,0)) as diff
from tab1 a left
join tab2 b on (a.name = b.name)