# Cobine 4 tables using join left query **URL:** \ **Category:** Ask for Help\ **Created:** [July 24, 2022, 10:46am UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143 "2022-07-24T10:46:51Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![D\_Leon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/d_leon/32/45015_2.png) [@D\_Leon](https://community.glideapps.com/u/D_Leon)\ **Post date:** [July 24, 2022, 10:46am UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143/1 "2022-07-24T10:46:52Z")
Hello community, I’ve been very frustrated trying to combine 4 tables in one so then I can analyze it. I’m going to explain It better: -First table (User Table): Employe Name - Rol -Second table (Courses) Course name - Frecuency to done again -Third table (Log\_Rol\_Courses) Course - Rol needed -Fourth table (Log\_Course\_Done) Employe - Course - Date course done -Query (combine the tables above): Employe (User Table) - Course Employe have to do by rol (Log\_Rol\_Courses) - Last date course was done (Log\_Course\_Done) - Frecuency to done again (Courses) - Date Next traingin (Formula: Last date course was done+Frecuency to done again) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f398ba9af117d700483edcfb7c73a3a33cf30a2.png) TheN I would like to have some other columns but if I get the query I think I won’t have problems. What I have on mind is: A departament updating the courses that need to be done by rol HR checking who have to do the courses, if they have done it and whe they have to do it again. Sometimes an employe change the roll so the query should update checkin the courses that the new rol requires I did all of that in “Excel power query” but I don’t now how to replicate that in glide. If anyone have an idea how I can achive this in glide please let me know, I would very apreciated. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 24, 2022, 1:38pm UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143/2 "2022-07-24T13:38:42Z")
Hola! I read your explanation but I had a confusion by reading “Join left query” with 4 tables. Nothing better than some images 😉 Here are the Join types that I know: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f056b4bdc5d0c6b8707795ee55d900dbc10afe96.png) But I wonder if in the end what you want is this but with 4 tables: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e54132af53466114ad90a6bde4e5d83aba61003d.jpeg) Saludos ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 24, 2022, 1:42pm UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143/3 "2022-07-24T13:42:01Z")
mmm, like @gvalero I find it a little difficult to follow what you are trying to do. But in general terms, when you need to “join” tables together in Glide, you use [Relations](https://docs.glideapps.com/all/product/data-editor/relations). ---
**Author:** ![D\_Leon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/d_leon/32/45015_2.png) [@D\_Leon](https://community.glideapps.com/u/D_Leon)\ **Post date:** [July 24, 2022, 3:15pm UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143/4 "2022-07-24T15:15:06Z")
Hola @gvalero , How I did it in excel power query is: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6a8d24ee9f287cd775b14a9aa0b795d164ad2ab.png) What I would like to get at the end is the last table where I can track: Employe name Rol Course must done regading rol Las day the course was done Day till next course updating Thank you very much ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 25, 2022, 1:39am UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143/5 "2022-07-25T01:39:08Z")
One question from me is do you really need that within one table? Would you achieve the same functionality of managing your data if you just keep them as 4 separate tables and construct appropriate relations & screens to manage those pieces of data? ---
**Author:** ![D\_Leon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/d_leon/32/45015_2.png) [@D\_Leon](https://community.glideapps.com/u/D_Leon)\ **Post date:** [July 25, 2022, 6:10am UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143/6 "2022-07-25T06:10:57Z")
Hello @ThinhDinh , For me is totaly fine to do it with separated tables but I don’t no how I can check the course that every persona must do vs. the last course he did (similar what I do in the last table) ---
**Author:** ![D\_Leon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/d_leon/32/45015_2.png) [@D\_Leon](https://community.glideapps.com/u/D_Leon)\ **Post date:** [August 31, 2022, 9:24am UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143/7 "2022-08-31T09:24:56Z")
I think I’ve solved the problem using google sheets and airtable options. Find below the videos that helped me: [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6f074ab1f42dd4b22c23c015e0dd4ba694396a6.jpeg "How to Use a Junction Table in your database | Airtable Tutorial") ](https://www.youtube.com/watch?v=O4JDCFKnzPo) https://www.youtube.com/embed/videoseries?list=PLv9Pf9aNgemvJdbQrfqXIRs8ssNujA8Vz&wmode=transparent&rel=0&autohide=1&showinfo=1&enablejsapi=1 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 1, 2022, 9:25am UTC](https://community.glideapps.com/t/cobine-4-tables-using-join-left-query/45143/8 "2022-09-01T09:25:19Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.