KnowledgeForum

Earn knowledge and go ahead in life

Saturday, 21 July 2012

joining tables from different database in informix

select t1.column,t2.column from tablename1 t1,dbname@server:tablename2;

example:
select e.name,d.name from employee e,sysdb@linux:department d where e.id=d.id;
Posted by Knowledge Forum at 21:04
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (6)
    • ►  October (5)
    • ►  March (1)
  • ►  2013 (5)
    • ►  December (5)
  • ▼  2012 (20)
    • ▼  July (20)
      • top 10 engineering colleges in bangalore
      • displaying only duplicate rows in oracle
      • DB import, export and DB load commands in Informix
      • Escape seqence in oracle queries
      • joining tables from different database in informix
      • latest news on technology
      • difference between count(*), count(age) and count(...
      • case in PL/SQl
      • dbschema of table in oracle
      • transaction recovery in Oracle
      • Informix database architecture
      • Important linux commands
      • dbschema of database in informix
      • UPSC exams
      • KPSC exams
      • VTU results
      • Civil Technical seminar PPT'S free download
      • Informix database
      • CS Technical seminar PPT'S free download
      • Database transaction management.

About Me

My photo
Knowledge Forum
I am passionate about Blogging
View my complete profile
Picture Window theme. Powered by Blogger.