Re: [SQL] Sum and count weird results

2004-08-15 Thread Michalis Kabrianis
Christoph Haller wrote: Michalis Kabrianis wrote: Hi all, I have these tables a ( id integer, email varchar); b ( seat varchar, transactionid varchar); c ( transactionid varchar, totalprice numeric(8.2)); ---(end of broadcast)--- TIP 8: explain analy

[SQL] Sum and count weird results

2004-08-05 Thread Michalis Kabrianis
Hi all, I have these tables a ( id integer, email varchar); b ( seat varchar, transactionid varchar); c ( transactionid varchar, totalprice numeric(8.2)); ---(end of broadcast)--- TIP 8: explain analyze is your friend