mysql sub-select work around?

[plug-discuss@lists.plug.phoenix.az.us]

Hi Mike,
I think this is what you're looking for.


drop table if exists tmp_idt;

create temporary table tmp_idt
SELECT (idt.unit * idt.price) AS Sub_Total
FROM idt WHERE idt.myid = "1";

select sum(Sub_Total) as 'total' from tmp_idt;



hope this helps.
Peter

On 5 Feb 2003 at 10:47, Mike Starke wrote:

> I know the new version of MySQL supports subselects,
> but I am just not ready for that upgrade. So here's my
> question:
> 
> I have a table called 'idt' with two columns "unit" and "price".
> How can I get an equivalent SQL statement that will work in
> MySQL 3.23
> 
> SELECT SUM
>         (
> 	SELECT (idt.unit * idt.price) AS Sub_Total
> 	FROM idt WHERE idt.myid = "1"
> 	)  AS Total 
> 	FROM idt
> 
> v/r
> -Mike
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change  you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> 
>