SQL JOIN functionality

Grid-View
1

Hi,

I am using nocodb to store iot data from devices
I have 2 tables
Table1 is a list of devices
Table2 is a list of the iot data sent from all the devices over time
Each record on Table2 is linked to a device from Table1
I want to create a gridview that only shows the LAST iot data entry from each device as well as all the device fields from Table1
In SQL I would just do a JOIN with a Group By or something like that.
How can I do it on nocodb?

Thanks
ps AMAZING PROJECT!

2

You can add LookUp field to bring in linked record information from another table. Details here.

You will not be able to control the order & number of linked records that get displayed though.

3

Created an issue here to track it further. You can vote up.