Database

SELECT Students.StudentID, CampusList_1.Name As Campus1,
   CampusList_2.Name As Campus2, CampusList_3.Name As Campus3,
   Students.Session1, Students.Session2, Students.Session3,
   Students.StudentName as FirstName,
   Students.StudentLastName as LastName,
   Students.DateOfBirth, Students.Street, Students.AppartmentNo,
   Students.City, Students.State, Students.ZipCode, Students.Phone,
   Students.ParentFirstName, Students.ParentLastName, Students.SSN,
   Students.SchoolYear, Students.Semester,
   iif(Students.Sibling, 'Yes', 'No') as Sibling,
   iif(Students.Accepted, 'Yes', 'No') as Accepted,
   iif(Students.Waitlisted, 'Yes', 'No') As Waitlisted,
   Students.ApplicationDate, Students.CurrentSchool,
   Students.AltenatePhone
FROM Students
LEFT JOIN CampusList AS CampusList_1
   ON Students.Campus1 = CampusList_1.CampusID
LEFT JOIN CampusList AS CampusList_2
   ON Students.Campus2 = CampusList_2.CampusID
LEFT JOIN CampusList AS CampusList_3
   ON Students.Campus3 = CampusList_3.CampusID
LEFT JOIN SessionTable AS Session_1
   ON Session_1.SessionId = Students.Session1
LEFT JOIN SessionTable AS Session_2
   ON Session_2.SessionId = Students.Session2
LEFT JOIN SessionTable AS Session_3
   ON Session_3.SessionId = Students.Session3
ORDER BY Students.StudentID

SELECT field1, field2 FROM mydatabase.dbo.table inner join myotherdatabase.dbo.table2 on field3 = field4

Shyam.r wrote:

u can use union,since both table has same structure

Exelioindia wrote:

how to write connection string to these databases commenly?

Exelioindia wrote:

also how to get data using an single query from those two database.

subbu.sk wrote:

can any one tell me what is SqlInjection in sql Server2005

subbu.sk wrote:

why should we go for SqlInjection and
in which situations.

Christian Graus wrote:

like I could be faster than you on a SQL injection question...

Christian Graus wrote:

like I could be faster than you on a SQL injection question...

subbu.sk wrote:

why should we go for SqlInjection