Inner join between 2 table

[Vincent_GUYADER]

Hi,
hope you are doing well, I’m quite a beginer on airtable, so my question could be a newbi one…
I will try to make an accurate and precise request

please have a look to the reproductible example here :

Airtable

Airtable | Everyone's app platform

Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free.

how can I add in the student table, the date_exam from the exam table ?
Bonus : Im my real usecase there is many exam per classroom, I need to have the more recent date.

Any Idea to do this ?

Regards

[Rose_K]

Hello and welcome to the Community @Vincent_GUYADER!

First of all thank you so much for sharing your base—it’s always great to be able to see what you are working with.

So it looks like you have a link from the Student table to the exam table—and you are already using a lookup field to pull the exam date for each student:

Vincent_GUYADER:

Bonus : Im my real usecase there is many exam per classroom, I need to have the more recent date.

If you are looking to pull the date for the most recent exam date for a classroom with many exams(I added two exams to the same classroom):

You can do so using a rollup field and the MAX() formula to find the maximum date (or most recent) date of the Exams for that classroom:

Now looking at that table you can see the most exam date is the one listed in the “Most Recent Exam Date” field:

Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .