This query works fine
SELECT MAX(customers.created_at) lst_trx_date, business_infos.id, business_infos.name as business_name, users.name as owner_name FROM users
INNER JOIN business_infos ON users.id = business_infos.user_id
INNER JOIN customers on business_infos.id = customers.businessId
GROUP BY customers.businessId
ORDER BY customers.created_at DESC
but this query getting an eerror
SELECT MAX(orders.date) lst_trx_date, business_infos.id, business_infos.name as business_name, users.name as owner_name FROM users
INNER JOIN business_infos ON users.id = business_infos.user_id
INNER JOIN orders on business_infos.id = orders.businessId
GROUP BY orders.businessId
ORDER BY orders.created_at DESC
1st query have small data and 2nd query have a large data what should i need to consider ?
Asked by Nullified
(25 rep)
Oct 26, 2022, 03:52 AM
Last activity: Jul 4, 2025, 01:03 AM
Last activity: Jul 4, 2025, 01:03 AM