#BRJAVA
Input
$Var0#KFZ-Kennzeichen:##
SQL
Select distinct sba_vg_akz as AKZ,
sba_vg_kennz as KFZKennz,
sba_vg_erfdat=BR_DATUM as Erfassungsdatum,
sba_vg_manr as Mitarbeiter
from sba_vgkontroll
where gueltig_bis = 0
and sba_vg_kennz like '$Var0%'
order by sba_vg_erfdat
Report
Java
Input
$Var0#KFZ-Kennzeichen:##
SQL
Select distinct sba_vg_akz as AKZ,
sba_schaub.sb_kennz as KFZKennz,
sba_schaub.sb_erfdat=BR_DATUM as Schaublattdatum,
bt.bt_name as Name,
bt.bt_vorname as Vorname,
sba_vg_erfdat=BR_DATUM as Erfassungsdatum,
sba_vg_manr as Mitarbeiter
from sba_schaub
join sba_zug on
sba_schaub.sb_nr = sba_zug.sb_nr
and sba_zug.gueltig_bis = 0
join sba_vgkontroll on
(sba_vgkontroll.sba_vg_akz = sba_zug.akz
or sba_vgkontroll.sba_vg_akz = sba_zug.akz_zugeordnet)
and sba_vgkontroll.gueltig_bis = 0
join bt on
bt.bt_nr = sba_schaub.sb_fahrer
and bt.gueltig_bis = 0
where sba_schaub.gueltig_bis = 0
and sba_schaub.sb_kennz like '$Var0%'
order by sba_schaub.sb_erfdat
Report
Java
|
