Sql Help

[PLANATRONICS]

can i join two tables which belong to different schema?

[Silver_mani]

DB links

[CheGuevara]

Why not

[buri]

grant chalu kada.. db link enduku

[electionszindabad]

different schema ee kadu different database lo tables kuda join cheyyachu.... 

linked server use cheste different servers lo vunna tbles kud join chesukovavhu

[patela_24]

<table_name> kaakunda <schema>.<table_name>  ani ivvu nee join statement lo..DB link is also an option 

 

For ex:

 

SELECT s.supplier_id, s.supplier_name, od.order_date
FROM <schema>.suppliers AS s
INNER JOIN <other_schema>.order_details AS od
ON s.supplier_id = od.supplier_id;

[PLANATRONICS]

Thanks Bhayya.... Trying from my end.