Re: [PHP] Problem whith query in query

2002-11-20 Thread Ryan Gallagher
Quoting Ernest E Vogelsinger <[EMAIL PROTECTED]>: > At 18:29 20.11.2002, Ryan Gallagher said: > [snip] > >SELECT * FROM identifisering as i > >WHERE i.identifiseringid = ( > >SELECT MAX(ii.identifiseringid) AS maxIdentifiseringid > >FROM identifiseri

Re: [PHP] Problem whith query in query

2002-11-20 Thread Ernest E Vogelsinger
At 18:29 20.11.2002, Ryan Gallagher said: [snip] >SELECT * FROM identifisering as i >WHERE i.identifiseringid = ( >SELECT MAX(ii.identifiseringid) AS maxIdentifiseringid >FROM identifisering as ii > ) >GROUP BY dprosjekt > >Now that I look at it, you

Re: [PHP] Problem whith query in query

2002-11-20 Thread Ryan Gallagher
Quoting Ernest E Vogelsinger <[EMAIL PROTECTED]>: > At 04:57 18.11.2002, Lars Espelid said: > [snip] > >I tought this would work, but it won't: > > > >SELECT * FROM identifisering as i > >WHERE i.identifiseringid=(SELECT MAX(ii.identifiseringid) > >FROM iden

Re: [PHP] Problem whith query in query

2002-11-20 Thread Ernest E Vogelsinger
At 04:57 18.11.2002, Lars Espelid said: [snip] >I tought this would work, but it won't: > >SELECT * FROM identifisering as i >WHERE i.identifiseringid=(SELECT MAX(ii.identifiseringid) >FROM identifisering as ii >GROUP BY dprosjekt); > >also tried: > >SELECT *

Re: [PHP] Problem whith query in query

2002-11-20 Thread Marek Kilimajer
you can use temporary tables: CREATE TEMPORARY TABLE tmp_name SELECT SELECT MAX(ii.identifiseringid) AS max_ii FROM identifisering as ii GROUP BY dprosjekt then: SELECT * FROM identifisering as i, tmp WHERE i.identifiseringid='123' AND i=identifiseringid=tmp.max_id; Lars Espelid wrote: Hello