Re: Help!!!
Yes. And now. If i send query
SELECT date.id, pump1.TVater1, `pump2`.PAir1
FROM date
RIGHT JOIN pump1 ON date.id = `pump1`.owner
RIGHT JOIN pump2 ON pump2.owner = date.id
WHERE date.id = ( SELECT MAX( id ) FROM date )
GROUP BY date.id, pump1.TVater1
i resive the replay
id TVater1 PAir1
5 20 30
bat there`s only 1 record, not 5
and i wont to get 5 of them
Subject
Written By
Posted
Re: Help!!!
April 05, 2005 01:43AM
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.