Forum: Datenbanken
by RWarnecke,
22. Jan 2010
Danke für den Tipp Markus, ich habe das jetzt so gelöst :
SELECT
G.stammnr, G.bd, g.vst, g.hst, g.ske, g.skv, g.af, g.gak, g.gar, g.gal,
g.gfnr, g.lkz, g.sz, g.lkzb, g.lkze, g.szb, g.sze, g.bs, g.krnr, g.gs,
g.gwv, g.gwvb, g.gwt, g.kz, g.bsv, g.br, skr.krname as LSKR, gsf.gf as LGF,
gw.s as LHebeSatz, gw.stadt as LStadt, g.kss
FROM Grunddaten G
INNER JOIN skrauswahl SKR ON...
Forum: Datenbanken
by RWarnecke,
22. Jan 2010
Hallo zusammen,
ich habe die folgende Abfrage :
SELECT
G.stammnr, G.bd, g.vst, g.hst, g.ske, g.skv, g.af, g.gak, g.gar, g.gal,
g.gfnr, g.lkz, g.sz, g.lkzb, g.lkze, g.szb, g.sze, g.bs, g.krnr, g.gs,
g.gwv, g.gwvb, g.gwt, g.kz, g.bsv, g.br, skr.krname as LSKR, gsf.gf as LGF,
gw.s as LHebeSatz, gw.stadt as LStadt, g.kss
FROM Grunddaten G