Operation =1
Option =0
Where ="(((tbl_kunden_solar.mep_kd_nummer)=[Lead ID angeben]))"
Begin InputTables
    Name ="tbl_kunden_solar"
    Name ="tbl_statustabelle"
    Name ="tbl_energievertrag"
End
Begin OutputColumns
    Expression ="tbl_kunden_solar.mep_kd_nummer"
    Expression ="tbl_kunden_solar.bcs_kd_nummer"
    Expression ="tbl_kunden_solar.kd_nachname"
    Expression ="tbl_statustabelle.Status_NR"
    Expression ="tbl_statustabelle.Status"
    Expression ="tbl_statustabelle.AD"
    Expression ="tbl_statustabelle.Termindatum"
    Expression ="tbl_statustabelle.Terminzeit"
    Expression ="tbl_statustabelle.Ergebnis"
    Expression ="tbl_statustabelle.Abschluss_Energy"
    Expression ="tbl_statustabelle.KWEnergie"
    Expression ="tbl_energievertrag.ID_EV"
    Expression ="tbl_energievertrag.Tarif"
End
Begin Joins
    LeftTable ="tbl_kunden_solar"
    RightTable ="tbl_statustabelle"
    Expression ="tbl_kunden_solar.bcs_kd_nummer = tbl_statustabelle.KD_NR"
    Flag =1
    LeftTable ="tbl_statustabelle"
    RightTable ="tbl_energievertrag"
    Expression ="tbl_statustabelle.Status_NR = tbl_energievertrag.Status_NR"
    Flag =2
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="tbl_statustabelle.Status"
        dbInteger "ColumnWidth" ="2205"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-6
    Top =-32
    Right =1722
    Bottom =1269
    Left =-1
    Top =-1
    Right =1713
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =134
        Bottom =120
        Top =0
        Name ="tbl_kunden_solar"
        Name =""
    End
    Begin
        Left =224
        Top =2
        Right =320
        Bottom =116
        Top =0
        Name ="tbl_statustabelle"
        Name =""
    End
    Begin
        Left =500
        Top =7
        Right =596
        Bottom =121
        Top =2
        Name ="tbl_energievertrag"
        Name =""
    End
End
