Recent content by SheepDog

I imported the Prospect_Applicant table inot the Campus6 DB here is the sql with the joins. I want to have Recruiter_Selected come back with all the recruiteres that have a -1 in the field designated as a Yes. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME...

Yes you are right with your question.

In your From Statement dbo.Institute.Prospect_Applicant INNER JOIN dbo.PEOPLE LEFT OUTER ON This ON is the area of incorrect syntax

When I try your sql in a new view I am getting an error Incorrect syntax near the keyword "ON

Here is the original query. I want recruiters that have them selected to appear in the results . The table Prospect_Applicant from Data Base Institute is there this info is. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME, dbo.PEOPLE.LAST_NAME...

Campus^ is the other db here is the code with what you sent abovae added, but am getting an error stating:Incorrect syntax near OUTER FROM OUTER JOIN dbo.Institute.Prospect_Applicant ON dbo.CAMPUS6.People ON...

I want to add the table from the other data base do I have to and make joins explained in the past post.

Join Data Base Institute, Table Prospect_Applicant, Field Recruiter_People_Code_ID to Table PEOPLE, Field PEOPLE_CODE_ID Join Data Base Institute, Table Prospect_Applicant, Field Applicant_People_ID to Table PEOPLE, Field PEOPLE_ID

I have the view listed below and want to add a table from another data base to it. The data base is Institute and the table is Prospect_Applicant. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME, dbo.PEOPLE.LAST_NAME, dbo.ACADEMIC.ACADEMIC_YEAR...

I have databases that I have created in Access 2003 that work fine, but in the last few days when I try to import a form and query into a new db it freezes up and works very slow. Can any one provide any insight as to what I can do to make it run alot faster like it should?

Has any one had a problem with Access 2003 locking up and not working or opening forms, queries, tables extremely slow. I created a new db and imported all the above into it and it still performs very slow!

I have the following code and need help in creating a left outer join with the People table using People_Code_ID as the join. Here is the dba db and table name. dbo.Institute.Prospect_Recruiter. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME...

How can I rem and add multiple subscribers in audix in order to clear the subscriber so a new person can add their own messages. If I export and import will this do what I want? When I select export do I have to put the extension(100) along with the number and follow the steps or is there...

What I want is that the Person's Id, name Max to Min Class Years like below. P000039178 Bob Jones 1951 HSG 1953 JCG 1955 SCG

It is Select_Recruiter