RelationShip of tables with views

• Sanjay Masawan

  Ten Centuries

  Points: 1031

  More actions

  January 21, 2005 at 12:24 am

  #162271

  I have two databases

  1) Database1 (Master1, View on table1, view on table2, view on table3)

  2) Database2 (Table1, Table2, Table3)

  The above is self explanatory. Now, I have a table Master1 in database 1 which I want to link to the View on table1 of database 2

  Sanjay Masawan

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  January 21, 2005 at 5:59 am

  #538485

  SELECT field1, field2, etc...

    FROM Database1.owner.Master1

      INNER JOIN Database2.owner.table1

  ????

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net