Forum Discussion

PijushRoy's avatar
PijushRoy
Community Champion
3 years ago
Solved

Need to run SQL Statement which is join by Two Database (Import/Direct Query/Live)

Hi Teams, Need to run SQL Statement which is join by Two Database. For Direct Query or Import, I need to specify the Server and Database name. Here issue is, in same SQL two database table are joi...
Need Help
  • Shahfaisal's avatar
    Shahfaisal
    3 years ago
    PijushRoy wrote:

    Shahfaisal 
    When you paste SQL Code in SQL Windows box, that time database is compulsary
    Please try.

    Yes, you will be required to if you are putting the sql code. However, you can just specify one of the databases in there. As long as you use three-part naming (specify database name in the code) you should be fine. For example, I just used te following (to show you) on my database server without any issues.

     

     

Shahfaisal's avatar
Shahfaisal
Solution Sage
3 years ago
PijushRoy wrote:

Shahfaisal 
When you paste SQL Code in SQL Windows box, that time database is compulsary
Please try.

Yes, you will be required to if you are putting the sql code. However, you can just specify one of the databases in there. As long as you use three-part naming (specify database name in the code) you should be fine. For example, I just used te following (to show you) on my database server without any issues.

 

 

PijushRoy's avatar
PijushRoy
Community Champion
3 years ago

Shahfaisal ?
Is the sql fetching/loading correct data? For me I am getting error. 
Please check and confirm

  • Shahfaisal's avatar
    Shahfaisal
    Solution Sage
    3 years ago
    PijushRoy wrote:

    Shahfaisal ?
    Is the sql fetching/loading correct data? For me I am getting error. 
    Please check and confirm

    It would get the correct data as long as your sql code is correct. As I mentioned before, please post you error message here.