Sample Header Ad - 728x90

Why im getting error 1114 the table is full?

0 votes
1 answer
199 views
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