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,
SSN -primary key
Job_Title_Code -primary key
Dept_ID -primary key
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?