SELECT
    *
FROM
    MY_SCHEMA.MY_TABLE@/*<DATABASE>*/MY_DB/*</DATABASE>*/ MY,
    YOUR_SCHEMA.YOUR_TABLE@/*<DATABASE>*/YOUR_DB/*</DATABASE>*/ YOUR
WHERE
    MY.JOIN_KEY = YOUR.JOIN_KEY