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...
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...
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...
I understand the concept of Max and Min for a criteria, but is there a way to bring back records that are between them as well. There are people who may have attended one class year or two class years or three class years.
Example:
Name Bob Jones 1980 High School 1984 Junior College 1986 Senior...
...query worked great before and now it does not work at all without any changes made to it.
Here is the query;
SELECT DISTINCT People_Information.*, dbo_Recruiter_Contact_Prospect_Select1.Recruiter_People_Code_ID, dbo_Recruiter_Contact_Prospect_Select1.Recruiter_FName...
The query will not work either for this report. All the tables in the query work yet the query will not work. It worked fine the other day without myself making any changes.
What causes # ERROR to show up where the data is supposed to be in a report. I know if you key in the wrong information for criteria of a query or have the report using a different query than what it should it will cause this error but this is not the case with me getting the # Error.
I have taken out the code above and it works as it should.
Now the problem I am having is that the report will list one record with just the office held field and all other fields blank. and then other records that have the same office held field.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.