1
I’m having trouble relating data from two tables.
I have two tables. Posts table and Favorites table.
Tabela Favoritos:
id, id_utilizador, id_post
1 109 20
2 200 20
3 105 104
4 109 150
-------------------------------------------
Tabela Posts:
id, id_post, id_owner, titulo, discricao
1 20 123 qqcoisa qqcoisa
2 150 321 xxxxx xxxxx
--------------------------------------------
I wanted to present on a page the user’s bookmarks id = 109, including the title and table of posts?
utilizador post titulo descricao
109 20 qqcoisa qqcoisa
109 150 xxxxxx xxxxx
Thanks @Rui Cardoso , already knew this INNER JOIN, but at your expense I could understand better how it works. Thanks. Hug!
– David Concha