I have the join condition as below
Select ct.payment,pm.order
from contract as ct
left join payment_order as pm
on ct.con_id=pm.id
Here the table payment_order is in another database 'payment'. How can i query this using dblink. please help.