I have a query table that pulls from 2 tables with 200k+ rows. When I try and save it it gives me the following error
The query is below.
select sales_details_t1.invoice_no, sales_details_t1.customer_name, sales_details_t1.item_desc, sales_details_t1.invoice_dt, sales_details_t1.invoice_litem_no, lineValue, sales_credit_t2.CreditValue, sales_details_t1.invoice_qty, sales_credit_t2.ret_qty, sales_details_t1.invoice_qty - sales_credit_t2.ret_qty as netSoldQty, lineValue - sales_credit_t2.CreditValue as netSalesValue from sales_details_t1 left join sales_credit_t2 on sales_details_t1.invoice_no = sales_credit_t2.invoice_no and sales_details_t1.invoice_litem_no = sales_credit_t2.invoice_litem_no