Operation =1
Option =0
Where ="(((tbl_energievertrag.Nachname)=[Nachname angeben]))"
Begin InputTables
    Name ="tbl_energievertrag"
    Name ="tbl_statustabelle"
    Name ="tbl_kunden_solar"
End
Begin OutputColumns
    Expression ="tbl_kunden_solar.mep_kd_nummer"
    Expression ="tbl_energievertrag.Vorname"
    Expression ="tbl_energievertrag.Nachname"
    Expression ="tbl_energievertrag.ID_EV"
    Expression ="tbl_energievertrag.Status_NR"
    Expression ="tbl_energievertrag.Tarif"
    Expression ="tbl_energievertrag.Provisioniert"
    Expression ="tbl_energievertrag.ProvisioniertDatum"
    Expression ="tbl_energievertrag.ProvisioniertAD"
    Expression ="tbl_energievertrag.ProvisioniertAdDatum"
    Expression ="tbl_energievertrag.AktuellerStatus"
    Expression ="tbl_energievertrag.DatumaktuellerStatus"
    Expression ="tbl_statustabelle.AD"
    Expression ="tbl_statustabelle.Termindatum"
    Expression ="tbl_statustabelle.Terminzeit"
End
Begin Joins
    LeftTable ="tbl_energievertrag"
    RightTable ="tbl_statustabelle"
    Expression ="tbl_energievertrag.Status_NR = tbl_statustabelle.Status_NR"
    Flag =1
    LeftTable ="tbl_statustabelle"
    RightTable ="tbl_kunden_solar"
    Expression ="tbl_statustabelle.KD_NR = tbl_kunden_solar.bcs_kd_nummer"
    Flag =2
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
End
Begin
    State =2
    Left =-6
    Top =-32
    Right =2562
    Bottom =1288
    Left =-1
    Top =-1
    Right =2553
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =457
        Bottom =120
        Top =2
        Name ="tbl_energievertrag"
        Name =""
    End
    Begin
        Left =692
        Top =8
        Right =788
        Bottom =122
        Top =8
        Name ="tbl_statustabelle"
        Name =""
    End
    Begin
        Left =1001
        Top =14
        Right =1097
        Bottom =128
        Top =0
        Name ="tbl_kunden_solar"
        Name =""
    End
End
