0

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.

Improve this question
2
  • Search for "executes a query" in the duplicate link. It shows a great example of how to use dblink. Commented Mar 20, 2018 at 1:24
  • Thank you for the duplicate link... That solved my question Commented Mar 20, 2018 at 2:31
Related questions
4343
How do I UPDATE from a SELECT in SQL Server?
1896
Insert into ... values ( SELECT ... FROM ... )
1698
How can I do an UPDATE statement with JOIN in SQL Server?
Load 4 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.