Can I do a detail page using two DB table queries?

I am sure this is very simple but I can’t work it out. Can I create a detail page using the following as an example. These would be the two database tables

And the page would have the results display as follows. So if you hover/click on the brand on the left (in this case tbl_brand, id=2 “Honda”), the models and descriptions associated to that brand would show on the right, and you can then click on the Edit button to bring up a modal with an update form.

I can do a single query Data Detail page but I can’t seem to work out how to do this. Is it possible or do I need to approach it in a different way?