Nested queries with mysql

A

admin

Administrator
Staff member
hi everyone!

i need to do this query from a php page:

SELECT prestazioni.*, Attivita.* FROM prestazioni INNER JOIN (Attivita INNER JOIN FrameworkPrestazioni ON Attivita.ID_Attivita = FrameworkPrestazioni.ID_Attivita_Framework) ON prestazioni.id_prestazione = FrameworkPrestazioni.ID_Prestazione_Framework WHERE prestazioni.id_prestazione=2

but mysql doesnt support nested queries:
how can i do?

thnx anyway
 
You must log in or register to reply here.
Back
Top