Query between two tables

[JCabral]

HI
I needed some help to make a query, to two tables that I have in an access file, which I only use to store data.
The query is done from Excel, but my difficulty is how to define the statement in SQL, since I'm not very knowledgeable about it either.

So that's it, I have two tables, tblTasks and tblRoutes.

In tblTasks I have the data referring to each Task, namely who does it (OIA), its designation (TASK DESIGNATION) and the extension of that task (INSPECTION EXTENSION).

In the table tblRoutes I have the data for each OIA to do during the week, that is, I have for a given OIA the name of the route it has to do (ROUTE) and what tasks it has to do on Monday, Tuesday, Wednesday, Thursday and Friday.

Important: The tables must have this format and I cannot change them.

The query I need to do is; for a given OIA and for a given Route I need to know the inspection extension (INSPECTION EXTENSION) carried out for each day of the week.

NOTE: I don't know if it's possible to put my access file here?

Thanks

 

[JCabral]

Yeah, that is usually the solution to issues like this - do a separate query for each day of the week, and use "UNION" to see each sub-query together.
Just note that the results of UNION queries are NOT updateable.

Please remember that I'm a beginner, when you say it's not updateable, what do you mean? As I mentioned in the post, the queries will be carried out from Excel, that is, whenever I need to, I make the query, the moment I make the query the data is updated.
I can always do 5 queries, one for each day of the week.

 

[Joe4]

It means that you will not be able to edit (add, delete, modify) any data in the query that is returned.
You can report on the data using a Union query, you just cannot make any changes to the data through the Union query.

 

[JCabral]

That is not a problem, because the data in the tables is changed separately, I just want to consult the values for each day of the week, given an OIA and a ROUTE