Hallo liebe Gemeinde =)
habe da ein kleines Problem... Ich würde gerne in meiner Bestehenden Abfrage
Select
CONTRACT.CONTRACT_NO As Vertragsnummer,
CUSTOMER.CUSTOMER_NO As Kundennummer,
CUSTOMER.CUSTOMER_NAME As Kundenname,
CUSTOMER.E_MAIL As KundenEMail,
MACHINE_ON_CONTRACT.CONTRACT_ACTIVE_FROM As VertragsBeginn,
MACHINE.MACHINE_NO As ServiceNr,
MACHINE.LOCATION As Location,
MODEL.MODEL_TYPE As ModelTyp,
MODEL.DESCRIPTION As ModelBeschreibung,
ADDRESS.PHONE_NO As PhoneNr,
ADDRESS.FAX_NO As FaxNr,
ADDRESS.POSTAL_CODE As PLZCode,
ADDRESS.ADDRESS_2 As Street,
EXTERNAL_ADDRESS.POST_LOCATION As Area,
METER.METER_TYPE,
CONTRACT_PERIOD_VOLUME.CONTRACT_PERIOD As VertragsPeriode,
[b]CONTRACT_METER_DETAILS.VOLUME As VolumeswA4[/b]
From
CONTRACT Inner Join
CUSTOMER On CONTRACT.CUSTOMER_OBJ_NO = CUSTOMER.OBJ_NO Inner Join
MACHINE_ON_CONTRACT On MACHINE_ON_CONTRACT.CONTRACT_OBJ_NO = CONTRACT.OBJ_NO Inner Join
MACHINE On MACHINE_ON_CONTRACT.MACHINE_OBJ_NO = MACHINE.OBJ_NO Inner Join
MODEL On MACHINE.MODEL_OBJ_NO = MODEL.OBJ_NO Inner Join
ADDRESS On CONTRACT.ADDRESS_ROW_NO = ADDRESS.ROW_NO And CUSTOMER.OBJ_NO = ADDRESS.SOURCE_OBJ_NO Inner Join
EXTERNAL_ADDRESS On ADDRESS.ROW_NO = EXTERNAL_ADDRESS.ROW_NO And CUSTOMER.CUSTOMER_NO = EXTERNAL_ADDRESS.CUSTOMER_NO Inner Join
METER_ON_CONTRACT On METER_ON_CONTRACT.CONTRACT_OBJ_NO = CONTRACT.OBJ_NO And METER_ON_CONTRACT.MACHINE_OBJ_NO = MACHINE.OBJ_NO Inner Join
METER On METER_ON_CONTRACT.METER_OBJ_NO = METER.OBJ_NO Inner Join
CONTRACT_PERIOD_VOLUME On CONTRACT_PERIOD_VOLUME.CONTRACT_OBJ_NO = CONTRACT.OBJ_NO Inner Join
CONTRACT_METER_DETAILS On CONTRACT_METER_DETAILS.CONTRACT_OBJ_NO = CONTRACT.OBJ_NO
Where
CONTRACT.CONTRACT_NO = '1348' And
METER.METER_TYPE = 'swA4' And
CONTRACT_METER_DETAILS.METER_OBJ_NO = '{0C3E01E9-D233-4650-98A9-4F43738C4E24}'
Ein weiteres Feld hinzufügen!
METER.METER_TYPE,
CONTRACT_METER_DETAILS.VOLUME As VolumecolA4
Da die Daten alle in einer anderen Zeile stehen bzw. eine eindeutige ID besitzen. Komme ich hier nicht weiter... hat Jemadn ne Idee?
MfG