I've got two tables that I want to be connected(let's call the A and B), so I made a third table. In table A and B i got two primary keys a_id and b_id. Now I create the third table named AB. Inside that I create ab_id as primary and two foreign keys with the names a_id and b_id..... all is all good right now, working fine.
Now to the issue, what should I write in the code to get example ab_id 1 to show all it's information. And by all information I mean all the info that a_id and b_id have in their tables. You get what I'm looking for here?
Does this require some kind of JOIN?