How can I do a select inside this select? MySQL

Question

This is my Select

SELECT id, name, price, category, url, image1 FROM `Products_items` WHERE active='y' and stockCount >= 1 ORDER BY views DESC

But I need to know column category_url from table Product_categories.

I tried this one but doesnt work

SELECT id, name, price, category, url, image1 FROM `Products_items` WHERE active='y' and stockCount >= 1 ORDER BY views DESC
SELECT url FROM Product_categories WHERE id=Products_items.category

Possible duplicate of [How can I join multiple SQL tables using the IDs?](http://stackoverflow.com/questions/9853586/how-can-i-join-multiple-sql-tables-using-the-ids) — Shadow, Apr 25 '17 at 14:11
It is absolutely unfair to edit your question and add some follow-up questions that were not in scope of the original one. If you have any follow-up questions, then ask them separately. Although, there are dozens of questions here on SO alone that deal with how to print out results of a query from php... — Shadow, Apr 25 '17 at 14:48

score 0 · Accepted Answer · edited Apr 25 '17 at 14:51

0

You can use a JOIN to join two tables, you have more information there. In case you have a foreign key on the products_items table related to the category you can do this:

SELECT a.id, a.name, a.price, a.category, b.url, a.image1 
FROM `Products_items` a 
LEFT JOIN Product b ON a.category_id = b.id 
WHERE a.active='y' and a.stockCount >= 1 ORDER BY a.views DESC

edited Apr 25 '17 at 14:51

Shadow

33,525
10
51
64

answered Apr 25 '17 at 14:10

Troyer

6,765
3
34
62

@LucasFerraz Check it now. – Troyer Apr 25 '17 at 14:22
You ROCK! Thank you so much! – Lucas Ferraz Apr 25 '17 at 14:49
1

Pls do not encourage incorrect behaviour by answering duplicate questions and then follow-up questions. – Shadow Apr 25 '17 at 14:51

score 0 · Answer 2 · answered Apr 25 '17 at 14:11

0

A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

SELECT * FROM Products_items as items JOIN Product_categories as categories ON items.category = categories.id;

answered Apr 25 '17 at 14:11

Vasili

895
7
12

How can I do a select inside this select? MySQL

2 Answers2