««Back to programs search page

You searched for programs: that have just been posted

SELECT DISTINCT tbl_Programs.Status, tbl_Programs.Opportunity, tbl_Institution.InstID, City, ZREF_tblState.State, tbl_Programs.ProgramID, Inactive, Institution, Web_Name, tbl_Programs.DateEntered, tbl_Programs.ApplicationDeadline, ProgramDescription, Fund_Intl_Students, Study_Abroad, Nationwide, PortableFunding, tbl_Programs.LastUpdated, Alliance FROM (((((tbl_Programs LEFT JOIN tbl_JOinProgramsDisciplines ON tbl_Programs.ProgramID = tbl_JoinProgramsDisciplines.ProgramID) LEFT JOIN tbl_JoinPrograms_tDescriptor ON tbl_Programs.ProgramID = tbl_JoinPrograms_tDescriptor.ProgramID) LEFT JOIN tbl_JoinProgramsKeywords ON tbl_Programs.ProgramID = tbl_JoinProgramsKeywords.ProgramID) LEFT JOIN tbl_JoinPrograms_tFunder ON tbl_Programs.ProgramID = tbl_JoinPrograms_tFunder.ProgramID) LEFT JOIN tbl_JoinPrograms_tUsergroup ON tbl_Programs.ProgramID = tbl_JoinPrograms_tUsergroup.ProgramID) INNER JOIN (tbl_JoinProgramsInstitutions INNER JOIN (tbl_Institution LEFT JOIN ZREF_tblState ON tbl_Institution.State = ZREF_tblState.State) ON tbl_JoinProgramsInstitutions.InstID = tbl_Institution.InstID) ON tbl_Programs.ProgramID = tbl_JoinProgramsInstitutions.ProgramID WHERE tbl_Programs.Inactive = 0 AND tbl_Institution.InstID NOT LIKE 'IBParticipation' AND (tbl_Programs.DateEntered > (GetDate() - 30)) ORDER BY tbl_Institution.Institution, tbl_Programs.Web_Name
Your search returned 1 programs.
You may want to consider removing or generalizing search criteria to obtain a higher number of results.