Again I find myself spoiled by PostgreSQL and it's nifty rewriting.. I'm trying to do this in SQLite :
SELECT *,(SELECT count(*) FROM invoice_master WHERE invoice_master.customer_id = customers.customer_id) FROM customers as; It's giving me "no such column: customers.customer_id" and I understand why. However, for the life of me I can't think of how to properly re-write that so SQLite will like it! Any help at all is appreciated! Thanks! __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
