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

 

[welshgasman]

Your routes table does not appear to be normalised.
Regardless, unless you can join them in some way, you are out of luck.
I am not sure OIA is going to work?, perhaps Goup on several fields?

 

[Joe4]

This is a classic example of how trying to work with tables that are not normalized can make what should be "simple tasks" extremely difficult to do.
Working with data that is not normalized can be a HUGE pain!

 

[welshgasman]

Now crossposted at Query between two tables

 

[Joe4]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!

If you have posted the question at other places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[JCabral]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!

If you have posted the question at other places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

I didn't put the link to the other post here, because it was pending on the other side, if you saw the post on the other side there was a link to this post.
Thank you very much for your answer

 

[JCabral]

Now crossposted at Query between two tables

I didn't put the link to the other post here, because it was pending on the other side, if you saw the post on the other side there was a link to this post.
Thank you very much for your answer

 

[JCabral]

NOTE: Also in here - Query between two tables

 

[Micron]

I don't have time to study this (leaving in minutes) but I suspect Union queries will be the only way.

 

[Joe4]

I don't have time to study this (leaving in minutes) but I suspect Union queries will be the only way.

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.