Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. SQL Query

SQL Query

Scheduled Pinned Locked Moved ASP.NET
databasetutorial
4 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    abglorie
    wrote on last edited by
    #1

    Please give me actual query for following action I want data from two different database to single table (as same field name) ex. database1.table1 as field database2.table2 as field result into database1.table3 as field how to write query thanking you abglorie

    B K N 3 Replies Last reply
    0
    • A abglorie

      Please give me actual query for following action I want data from two different database to single table (as same field name) ex. database1.table1 as field database2.table2 as field result into database1.table3 as field how to write query thanking you abglorie

      B Offline
      B Offline
      Brij
      wrote on last edited by
      #2

      This is ASP.Net forum.It'll be better if you ask your question in "General Database" forum.

      Cheers!! Brij

      1 Reply Last reply
      0
      • A abglorie

        Please give me actual query for following action I want data from two different database to single table (as same field name) ex. database1.table1 as field database2.table2 as field result into database1.table3 as field how to write query thanking you abglorie

        K Offline
        K Offline
        keyur satyadev
        wrote on last edited by
        #3

        select * from FirstDatabase.dbo.Table1 t1 join SecondDatabase.dbo.Table2 t2 on t1.id=t2.id where (your condition if any)

        Regards Keyur Satyadev

        1 Reply Last reply
        0
        • A abglorie

          Please give me actual query for following action I want data from two different database to single table (as same field name) ex. database1.table1 as field database2.table2 as field result into database1.table3 as field how to write query thanking you abglorie

          N Offline
          N Offline
          Not Active
          wrote on last edited by
          #4

          abglorie wrote:

          Please give me actual query

          No, we are not here to do your work.


          I know the language. I've read a book. - _Madmatt

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups