Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Arrow Unanswered: create a view of or select from a table on another DB

    Does anyone know how you could create a view in one db of a table in another db on the same sql server? or how to perform a cross db join in a query?

    thanks!

  2. #2
    Join Date
    Sep 2003
    Posts
    16
    Eg;
    create view temp as
    select a.* from
    master..syslogins a, msdb..sysjobs

    Use the books online feature that comes with SQL server. Most useful!
    Meera

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •