MySQL Forums
Forum List  »  Views

Re: variable rows to columns in a dynamic view
Posted by: Miguel Martin
Date: June 17, 2011 05:19AM

Mmm... I was trying filter with a field aliased in the SQL query:

SELECT muestras.*, IF(pm.propiedad = "Estudio", pm.valor, "") AS `P_Estudio`
FROM propiedadesmuestra AS pm INNER JOIN muestras ON muestrasbase.idMuestra = muestras.idMuestra
WHERE `P_Estudio` = `RMT`;

And this is not possible right?
Is it possible to do something like this without a query of this query?

Anyway thanks a lot for your response.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: variable rows to columns in a dynamic view
2092
June 17, 2011 05:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.