如何从SQL中的两个不同表中选择值

Question

I have two tables in my SQL Server database. The first is catgeories and second is products. There is a column categories_id in both tables.

HERE IS MY TABLE FOR CATEGORIES :

+----+----------+----------+
| id | category | parent   |
+----+----------+----------+
|  1 | BOY      | 0        |
|  2 | GIRL     | 0        |
|  3 | SHIRT    | 1        |
|  4 | SKIRT    | 2        |
|  5 | JACKET   | 1        |
+----+----------+----------+

TABLE : PRODUCTS

+-------+--------------+----------------------+
| id    | title        |PRICE | Categories    |
+-------+--------------+------+---------------+
| 1     | RED SHIRT    | 300  |     3         |
| 2     | blue SKIRT   | 500  |     4         |  
| 3     | jeans jacket | 500  |     3         |           
+-------+--------------+------+-----+---------+

Now I want to select the values from Products table for a particular category like BOY.

Answer 1

 SELECT products.* FROM products INNER JOIN categories ON products.categories = categories.id WHERE categories.category LIKE '%BOY%';

Use this query..