Operation =1
Option =0
Where ="(((tbl_retention_daten.Monat_Jahr)=[Datum Monat Jahr eingeben]))"
Begin InputTables
    Name ="tbl_retention_daten"
    Name ="tbl_statustabelle"
End
Begin OutputColumns
    Expression ="tbl_statustabelle.KD_NR"
    Expression ="tbl_retention_daten.Status_Nr"
    Expression ="tbl_retention_daten.Firma"
    Expression ="tbl_retention_daten.ID"
    Expression ="tbl_retention_daten.Sachbearbeiter"
    Expression ="tbl_retention_daten.MSISDN"
    Expression ="tbl_retention_daten.RETENTION_CLASS"
    Expression ="tbl_retention_daten.TARIF"
    Expression ="tbl_retention_daten.CONTRACT_START_DATE"
    Expression ="tbl_retention_daten.CONTRACT_END_DATE"
    Expression ="tbl_retention_daten.RVK"
    Expression ="tbl_retention_daten.BIRTHDAY"
    Expression ="tbl_retention_daten.Datum_Brief"
    Expression ="tbl_retention_daten.Monat_Jahr"
    Expression ="tbl_retention_daten.Import_Datum"
    Expression ="tbl_retention_daten.Bearbeitet"
    Expression ="tbl_retention_daten.Buchungsnummer"
    Expression ="tbl_retention_daten.abgefragt_am"
    Expression ="tbl_retention_daten.Buchungsnr_beantragt"
    Expression ="tbl_retention_daten.Hardewarebonus"
    Expression ="tbl_retention_daten.Provisioniert"
    Expression ="tbl_retention_daten.Prov_Datum"
    Expression ="tbl_retention_daten.Tarifwechsel"
    Expression ="tbl_retention_daten.Tarifbezeichnung"
End
Begin Joins
    LeftTable ="tbl_retention_daten"
    RightTable ="tbl_statustabelle"
    Expression ="tbl_retention_daten.Status_Nr = tbl_statustabelle.Status_NR"
    Flag =1
End
Begin OrderBy
    Expression ="tbl_statustabelle.KD_NR"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="tbl_retention_daten.Status_Nr"
        dbInteger "ColumnOrder" ="3"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.KD_NR"
        dbInteger "ColumnOrder" ="2"
    End
    Begin
        dbText "Name" ="tbl_retention_daten.Firma"
        dbInteger "ColumnOrder" ="4"
    End
    Begin
        dbText "Name" ="tbl_retention_daten.ID"
        dbInteger "ColumnOrder" ="5"
    End
    Begin
        dbText "Name" ="tbl_retention_daten.Sachbearbeiter"
        dbInteger "ColumnOrder" ="1"
    End
End
Begin
    State =2
    Left =-4
    Top =-30
    Right =2560
    Bottom =1262
    Left =-1
    Top =-1
    Right =2557
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =451
        Bottom =120
        Top =0
        Name ="tbl_retention_daten"
        Name =""
    End
    Begin
        Left =489
        Top =6
        Right =585
        Bottom =120
        Top =0
        Name ="tbl_statustabelle"
        Name =""
    End
End
