[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 orders WHERE user_id='".$user."') ORDER BY factura_id";
... don't even know if this will work:
SELECT DISTINCT
f.*
FROM facturas f, orders o
WHERE
f.pedido = o.orders_id AND
o.user_id = '$user'
ORDER BY f.factura_id;
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
