Problem with query.

Question

Help, how to make a query? I need from the List to add the new data in table 1: category, date, description, and category (category id). But the text of the category  want to find in the other table name of Category and add in table 1 id  this category.
Can't properly write the query. Help please.