How to get the desired values ​​from mySQL (connection)?

Question

MySQL

I need to get data from a database table, according to certain parameters:
I select all tags from one table -

SELECT * FROM prefix_record_tag WHERE tag = 'my tag'

It returns a certain result in the form of columns - ID of the tag, ID of the material to which the tag belongs, tag.
I need to get data from prefix_record_descirption by the "material ID" parameter - all the results that match in the record_id field. How can I do it?

Answer 1

As far as I understand, you need a LEFT JOIN
query like:
SELECT "here are all the fields from the two tables that you need" FROM prefix_record_tag
​​LEFT JOIN prefix_record_descirption ON (prefix_record_tag.material_id = prefix_record_descirption.record_id)
WHERE prefix_record_tag.tag = 'my tag'
is rather pseudo code, but the gist is hopefully. clear.