mysql Summarize multiple select statements

Asked 1 months ago, Updated 1 months ago, 1 views

Would it be possible to combine the following two select statements into one?

select name, img, price from items where id=:request

select item_title from categories where id=:request

Please let me know if you know more.Thank you for your cooperation.

mysql

2022-09-30 11:55

1 Answers

SELECT a.name, a.img, a.price, b.item_title 
FROM items ASa 
INNER JOIN CATEGORIES ASBON a.id = b.id 
WHERE a.id=:request


2022-09-30 11:55

If you have any answers or tips


© 2022 OneMinuteCode. All rights reserved.