Selecting data from two databases within MSSQL

[teju]

Hello,
I would like to know whether is it possible to select data from two different databases within the same sql server.
For example
I have one database as StudentList which is the central database for students and i have other database as courseselection

i want to select the student no from the student list database and enter the course selection in the course selection database.

Could some one advice me whar would be the optmistic way of doing it

Regards,
Teju.

[helloiamhere]

Hello,
I would like to know whether is it possible to select data from two different databases within the same sql server.
For example
I have one database as StudentList which is the central database for students and i have other database as courseselection

i want to select the student no from the student list database and enter the course selection in the course selection database.

Could some one advice me whar would be the optmistic way of doing it

Regards,
Teju.

Ya It is possible
Query to get the studentno and the course selected

select StudentList.dbo .[tablename].student no, CourseSelection .dbo.[tablename].courseselected from StudentList.dbo .[tablename],CourseSelectio n.dbo.[tablename]

[teju]

Ya It is possible
Query to get the studentno and the course selected

select StudentList.dbo .[tablename].student no, CourseSelection .dbo.[tablename].courseselected from StudentList.dbo .[tablename],CourseSelectio n.dbo.[tablename]

It throws an error back
StudentList object name not found.

Thanks

[almaz]

The query posted by helloiamhere is just a sample of how you should refer to different databases.
StudentList and CourseSelection are DATABASE names

[helloiamhere]

It throws an error back
StudentList object name not found.

Thanks

Ofcourse the another reply defines the solution. For the details you posted i gave a sample query...

just try the same with the database you have in your server.