Database

select Name, Rank from MyTable
order by case when Rank = 0 then 'B' else 'A' end, Name

Jerry0288 wrote:

Include city/state of location

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