| Linklist |
Example 1 (Informix):
SELECT a.vnum, a.vname, b.kname
FROM tverkauf a, OUTER tkunden b
WHERE a.vnum = b.vnum;
Select all salesman with their customers, but select salesman without customers too.
Example 2 (Standard-SQL):
SELECT a.vnum, a.vname, b.kname
FROM tverkauf a, tkunden b
WHERE a.vnum = b.vnum
UNION
SELECT vnum, vname, '____________'
FROM tverkauf
WHERE vnum NOT IN
( SELECT vnum FROM tkunden );
Select all salesman with their customers, but select salesman without customers too.
Example 3 (some other RDBMS):
SELECT a.vnum, a.vname, b.kname
FROM tverkauf a, tkunden b
WHERE a.vnum(+) = b.vnum;
Select all salesman with their customers, but select salesman without customers too.