469,610 Members | 1,934 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

Need guidance on and SQL problem

Hi, I'm taking my first and only SQL course (just trying to get my
degree as I prefer network administration and loathe any type of
programming per se) and I have the following problem.

If I have the 4 tables that I created in MS Access and have populated
with information, for instance,

Table: Emp_Info
SSN -primary key
Emp_Name
Address
Telephone
Email
Job_Title_Code
Dept_ID
Hire_Date
Salary

Table: Job_Title_Info
Job_Title_Code -primary key
Job_Title
Exempt
Non-Exempt
Min_Salary
Max_Salary

Table: Dept_Info
Dept_ID -primary key
Dept_Name
Dept_Location
Dept_Head

What I want to do is
Write three SQL queries:

· The first query joins two tables in the above example database and
uses BETWEEN to restrict record selection.

· The second query joins two tables in the above example database and
uses LIKE to restrict record selection.

· The third query uses UNION to join two of the tables

Now, I can do the query in MS Access but is there a way to convert
that into SQL within the MS Access application? How would the SQL
query be written if there is no conversion?

Thanks.
Jul 19 '05 #1
3 1499
RP

"Shawn Carter" <in*@techie.com> schreef in bericht
news:de**************************@posting.google.c om...
Hi, I'm taking my first and only SQL course ..
..
..
What I want to do is
Write three SQL queries:

· The first query joins two tables in the above example database and
uses BETWEEN to restrict record selection.

· The second query joins two tables in the above example database and
uses LIKE to restrict record selection.

· The third query uses UNION to join two of the tables

Now, I can do the query in MS Access but is there a way to convert
that into SQL within the MS Access application? How would the SQL
query be written if there is no conversion?

Thanks.


An Access question in a Mysql newsgroup. How brave.
In the query-builder screen choose view | SQL from the menu, and you have
what you want. Some editting will be necessary I'm afraid.

Good luck with your course :o)
RP
Jul 19 '05 #2
RP

"Shawn Carter" <in*@techie.com> schreef in bericht
news:de**************************@posting.google.c om...
Hi, I'm taking my first and only SQL course ..
..
..
What I want to do is
Write three SQL queries:

· The first query joins two tables in the above example database and
uses BETWEEN to restrict record selection.

· The second query joins two tables in the above example database and
uses LIKE to restrict record selection.

· The third query uses UNION to join two of the tables

Now, I can do the query in MS Access but is there a way to convert
that into SQL within the MS Access application? How would the SQL
query be written if there is no conversion?

Thanks.


An Access question in a Mysql newsgroup. How brave.
In the query-builder screen choose view | SQL from the menu, and you have
what you want. Some editting will be necessary I'm afraid.

Good luck with your course :o)
RP
Jul 19 '05 #3
RP

"Shawn Carter" <in*@techie.com> schreef in bericht
news:de**************************@posting.google.c om...
Hi, I'm taking my first and only SQL course ..
..
..
What I want to do is
Write three SQL queries:

· The first query joins two tables in the above example database and
uses BETWEEN to restrict record selection.

· The second query joins two tables in the above example database and
uses LIKE to restrict record selection.

· The third query uses UNION to join two of the tables

Now, I can do the query in MS Access but is there a way to convert
that into SQL within the MS Access application? How would the SQL
query be written if there is no conversion?

Thanks.


An Access question in a Mysql newsgroup. How brave.
In the query-builder screen choose view | SQL from the menu, and you have
what you want. Some editting will be necessary I'm afraid.

Good luck with your course :o)
RP
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by new_GUY | last post: by
reply views Thread by Patrick.O.Ige | last post: by
6 posts views Thread by sivashankar | last post: by
5 posts views Thread by inetquestion | last post: by
2 posts views Thread by csman24 | last post: by
8 posts views Thread by SanjaiGandhi | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.