Seleccionar una columna, conseguir 4

[diego_hanseatico]

Sí, muchas gracias:

companyProcessId, payment, deletion, verification

PROCESS_TYPE
ID NAME
1 delete
2 cancel
3 payment


COMPANY_PROCESS
ID ID_PROCESS_TYPE ID_INVOICE
1 2 65
2 1 75
3 2 66
4 1 54
5 1 45


PROCESS_LOG
ID ID_COMPANY_PROCESS DATE
1 3 25.12.2009 12:06:14
2 5 25.12.2009 15:05:12
3 2 25.12.2009 18:55:28
4 1 25.12.2009 19:42:15
5 4 25.12.2009 22:21:00


RESULTADO:

INVOICE-NR DATE_DELETION DATE_CANCELLATION DATE_PAYMENT
65 null 25.12.2009 19:42:15 null
75 25.12.2009 18:55:28 null null
66 null 25.12.2009 18:55:28 null