ra_id='".$order."' AND o.orders_id=f.pedido);
Thanks all,
Tomás
-Mensaje original-
De: Felix Geerinckx [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 11 de enero de 2007 19:25
Para: mysql@lists.mysql.com
Asunto: Re: Need any that can translate this
[EMAIL PROTECTED] (To
Temporary tables are stored in memory so they are as quick as joins.
Dusan
Ran napsal(a):
Not necessarily to use temp tables,they are expensicve.
Temp tables introduce extra disk IOs which slows down compare to using
explicit JOINs which is done in memory.
Here is techniques on how to rewrite
Not necessarily to use temp tables,they are expensicve.
Temp tables introduce extra disk IOs which slows down compare to using
explicit JOINs which is done in memory.
Here is techniques on how to rewrite a subquery with JOINs:
http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html
Ran
[EMAIL PROTECTED] (Tomás Abad Fernández) wrote in
news:[EMAIL PROTECTED]:
> I dont know why thease don't work at MySql 3.21 , anyone can help me
> to make this compatible with mysql3?
3.21 is really ancient ...
>
> $query = "SELECT * FROM facturas WHERE pedido IN (SELECT orders_id
> FROM order
Ysgrifennodd Tomás Abad Fernández:
I dont know why thease don't work at MySql 3.21 , anyone can help me to make
this compatible with mysql3?
$query = "SELECT * FROM facturas WHERE pedido IN (SELECT orders_id FROM
orders WHERE user_id='".$user."') ORDER BY factura_id";
Thanks for all.
If
I dont know why thease don't work at MySql 3.21 , anyone can help me to make
this compatible with mysql3?
$query = "SELECT * FROM facturas WHERE pedido IN (SELECT orders_id FROM
orders WHERE user_id='".$user."') ORDER BY factura_id";
Thanks for all.