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
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
© 2024 OneMinuteCode. All rights reserved.