SELECT
Organisation.organisationID,
Organisation.name,
Organisation.taxNumber,
Organisation.registrationNumber,
Organisation.addressID,
Organisation.description,
Organisation.phoneNumberID,
Organisation.faxNumberID,
Organisation.emailAddressID
INTO
:organisationID,
:name,
:taxNumber,
:registrationNumber,
:addressID,
:description,
:phoneNumberID,
:faxNumberID,
:emailAddressID
FROM
Organisation,
OrgBankAccountLink
WHERE OrgBankAccountLink.bankAccountID = :bankAccountID
AND OrgBankAccountLink.organisationID = Organisation.organisationID
|