Operation =1
Option =0
Where ="(((tbl_statustabelle.[WV Datum]) Is Not Null))"
Begin InputTables
    Name ="qry_LeadEingangKw_1"
    Name ="tbl_kunden_solar"
    Name ="tbl_statustabelle"
End
Begin OutputColumns
    Expression ="qry_LeadEingangKw_1.lead_id"
    Expression ="qry_LeadEingangKw_1.Location"
    Expression ="qry_LeadEingangKw_1.Kampagne"
    Expression ="qry_LeadEingangKw_1.bcs_kd_nummer"
    Expression ="qry_LeadEingangKw_1.QuelleSave"
    Expression ="qry_LeadEingangKw_1.[Eingang KW]"
    Expression ="qry_LeadEingangKw_1.create_datetime"
    Expression ="qry_LeadEingangKw_1.[Eingang Datum]"
    Expression ="qry_LeadEingangKw_1.Kurz"
    Expression ="tbl_kunden_solar.obj_postleitzahl"
    Expression ="tbl_statustabelle.Status"
    Expression ="tbl_statustabelle.[WV Datum]"
    Alias ="PLZ 2 Stellen"
    Expression ="Left([obj_postleitzahl],2)"
End
Begin Joins
    LeftTable ="qry_LeadEingangKw_1"
    RightTable ="tbl_kunden_solar"
    Expression ="qry_LeadEingangKw_1.bcs_kd_nummer = tbl_kunden_solar.bcs_kd_nummer"
    Flag =1
    LeftTable ="tbl_kunden_solar"
    RightTable ="tbl_statustabelle"
    Expression ="tbl_kunden_solar.bcs_kd_nummer = tbl_statustabelle.KD_NR"
    Flag =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="-1"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="tbl_kunden_solar.obj_postleitzahl"
        dbInteger "ColumnWidth" ="1530"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Status"
        dbInteger "ColumnWidth" ="2775"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-30
    Right =2560
    Bottom =1241
    Left =-1
    Top =-1
    Right =2557
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =276
        Bottom =120
        Top =0
        Name ="qry_LeadEingangKw_1"
        Name =""
    End
    Begin
        Left =476
        Top =-9
        Right =572
        Bottom =105
        Top =0
        Name ="tbl_kunden_solar"
        Name =""
    End
    Begin
        Left =801
        Top =1
        Right =897
        Bottom =115
        Top =4
        Name ="tbl_statustabelle"
        Name =""
    End
End
