>> SELECT *,(SELECT count(*) FROM invoice_master WHERE
>> invoice_master.customer_id = customers.customer_id)
>> FROM customers as;
You can't do correlated subqueries in SQLite, for the reasons
given in the 'Features not supported' document.
Try something like
select customers.*, Icount from
customers join (
select customer_id as Icust, count(*) as Icount
from invoice_master group by Icust)
on customer_id = Icust;
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
