#BRJAVA
INPUT
$VAR1#Nachname: ###bt.bt_name_norm like '$Var1%'
$VAR2#Vorname: ###bt.bt_vorname_norm like '$Var2%'
$VAR3#Geburtsdatum: ##$DATUM#bt.bt_geb_tag like '$VAR3_NORM_DATUM%'
$VAR4#Fahrerkartennummer: ###sba_schaub.card_id like '$VAR4%'
SQL
Select distinct bt.bt_nr,
bt.bt_name as Name,
bt.bt_vorname as Vorname,
bt.bt_plz + ' ' + bt.bt_gem_name + ' ' + bt.bt_strasse as Adresse,
bt.bt_geb_tag=$BR_DATUM as Geburtsdatum,
sba_schaub.card_id as Kartennummer
From bt, sba_schaub
Where bt.bt_nr = sba_schaub.sb_fahrer
and $Var1
and $Var2
and $Var3
and $Var4
#and sba_schaub.card_id is not NULL
#and sba_schaub.card_id <> ''
and bt.gueltig_bis = 0
and sba_schaub.gueltig_bis = 0
Report Table
|
