FS-Fotos vorhanden

ident not in (select adr_ident from dba.ADRESSCARDS where kind = 'lic' and state = 0) and ident in (select fk_ident from dba.IMAGES_ASSOCIATION where fk_table = 'ADRESSES_LICENSE')

order by (optional):

day(Dba.Adresses.Birth)

Führerscheinprüfung ausstehend

ident in (select adr_ident from dba.adresscards where kind = 'LIC' and isnull(locked, 0) = 1)

and zip <> 'TEST'

order by (optional):

day(Dba.Adresses.Birth)

Ohne FS-Fotos

ident not in (select adr_ident from dba.ADRESSCARDS where kind = 'lic' and state = 0) and ident not in (select fk_ident from dba.IMAGES_ASSOCIATION where fk_table = 'ADRESSES_LICENSE') and FDATE > '2019-07-01'

order by (optional):

day(Dba.Adresses.Birth)

Führerscheinprüfung erfolgt

ident in (select adr_ident from dba.adresscards where kind = 'LIC' and isnull(locked, 0) = 0)

and zip <> 'TEST'

order by (optional):

day(Dba.Adresses.Birth)