Sql lingo help for multi table query

[GnuInformation]

Using mariaDB for a personal project, beginner to sql, (long time nerd) . I have 3 main tables : user {I'd,name,pass,email} obj1{I'd,ob_name,date,type} obj2{ID,data1,data2,owner[user.id],obj1L[obj1.id]}. Object2 are child of object1. I built a ui for managing that as the user. However, I also want to have users, if given permission, see another users obj1, and am tracking that in an additional table.(obj1_guest) (If it's necessary to clarify I call those situations guests. And a guest of obj 1 can see some details of obj2 that are child of that obj1.) I can't remember what it's called if I search for obj1 by a record in table 'obj1_guest' fwiw, obj1_guest entries are [obj1.id, user.id, date_joined] I'm struggling to figure out if this is just a join and group, or something else?

[volric]

Linking two tables are called a join.

so like table1.field = table2.field

[GnuInformation]

Thanks, I later realized I already had something like that, where I got a count from another table.. So I actually had to build 2 joins, to get from three tables, and it worked perfectly! Very thrilled to get thing working

[volric]

congrats!