Operation =1
Option =0
Where ="(((qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.[Fehende Verträge])>0))"
Begin InputTables
    Name ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin"
    Name ="qry_MepVertragletzterstatus2"
    Name ="tbl_energievertrag"
    Name ="tbl_kunden"
    Name ="tbl_kunden_solar"
    Name ="tbl_statustabelle"
End
Begin OutputColumns
    Expression ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.lead_id"
    Expression ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.bcs_kd_nummer"
    Expression ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.[Abschluss Anlage]"
    Expression ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.[Anlagen laut V SST]"
    Expression ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.[Fehende Verträge]"
    Expression ="qry_MepVertragletzterstatus2.datum"
    Expression ="qry_MepVertragletzterstatus2.status"
    Expression ="qry_MepVertragletzterstatus2.[mep-vertrag]"
    Expression ="qry_MepVertragletzterstatus2.kwh"
    Expression ="qry_MepVertragletzterstatus2.[bcs-status]"
    Expression ="qry_MepVertragletzterstatus2.tbl_energietarife_id_et"
    Expression ="tbl_energievertrag.ID_EV"
    Expression ="tbl_energievertrag.Tarif"
    Alias ="Name Mobilfinkkunde"
    Expression ="tbl_kunden.Name"
    Alias ="Name Kunden Solar"
    Expression ="tbl_kunden_solar.kd_nachname"
    Expression ="tbl_statustabelle.AD"
    Expression ="tbl_statustabelle.Termindatum"
End
Begin Joins
    LeftTable ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin"
    RightTable ="qry_MepVertragletzterstatus2"
    Expression ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.lead_id = qry_MepVertragletzterstatus2"
        ".lead_id"
    Flag =1
    LeftTable ="qry_MepVertragletzterstatus2"
    RightTable ="tbl_energievertrag"
    Expression ="qry_MepVertragletzterstatus2.[bcs-status] = tbl_energievertrag.Status_NR"
    Flag =2
    LeftTable ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin"
    RightTable ="tbl_kunden"
    Expression ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.bcs_kd_nummer = tbl_kunden.KD_NR"
    Flag =1
    LeftTable ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin"
    RightTable ="tbl_kunden_solar"
    Expression ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin.bcs_kd_nummer = tbl_kunden_solar.bcs_k"
        "d_nummer"
    Flag =1
    LeftTable ="qry_MepVertragletzterstatus2"
    RightTable ="tbl_statustabelle"
    Expression ="qry_MepVertragletzterstatus2.[bcs-status] = tbl_statustabelle.Status_NR"
    Flag =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="qry_MepVertragletzterstatus2.datum"
        dbInteger "ColumnWidth" ="1950"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_MepVertragletzterstatus2.status"
        dbInteger "ColumnWidth" ="2775"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_MepVertragletzterstatus2.[mep-vertrag]"
        dbInteger "ColumnWidth" ="1785"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_MepVertragletzterstatus2.tbl_energietarife_id_et"
        dbInteger "ColumnWidth" ="2070"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Name Mobilfinkkunde"
        dbInteger "ColumnWidth" ="2040"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Name Kunden Solar"
        dbInteger "ColumnWidth" ="1920"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-6
    Top =-32
    Right =2562
    Bottom =1269
    Left =-1
    Top =-1
    Right =2553
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =257
        Bottom =120
        Top =3
        Name ="qry_LeadEingangKw_1_mitKW_Anruf_KW_Termin"
        Name =""
    End
    Begin
        Left =378
        Top =-2
        Right =633
        Bottom =112
        Top =4
        Name ="qry_MepVertragletzterstatus2"
        Name =""
    End
    Begin
        Left =880
        Top =2
        Right =976
        Bottom =116
        Top =3
        Name ="tbl_energievertrag"
        Name =""
    End
    Begin
        Left =1189
        Top =0
        Right =1285
        Bottom =114
        Top =4
        Name ="tbl_kunden"
        Name =""
    End
    Begin
        Left =1444
        Top =6
        Right =1540
        Bottom =120
        Top =5
        Name ="tbl_kunden_solar"
        Name =""
    End
    Begin
        Left =1697
        Top =3
        Right =1793
        Bottom =117
        Top =8
        Name ="tbl_statustabelle"
        Name =""
    End
End
