OPEN DATABASE "db";

FIELD name = name1 & " " & name2;

SELECT kundnr, suchnam, name, umsatz1__1
FROM kunden
WHERE umsatz1__1 > 0
ORDER BY kundnr;
