next time post a dump. so i can just copy paste it and then have all the data. no way i'm gonna copy all that data row by row!
> SELECT date.id, pump1.TVater1, `pump3`.TVater1
> FROM date
> LEFT JOIN pump1 ON pump1.owner = date.id
> LEFT JOIN pump3 ON `pump3`.owner=date.id
> WHERE date.id = ( SELECT date.id FROM date where date=(Required date is here ) )
> GROUP BY pump1.id,date.id
why do you have a subquery?!
wouldnt that be the same:
SELECT date.id, pump1.TVater1, `pump3`.TVater1
FROM date
LEFT JOIN pump1 ON pump1.owner = date.id
LEFT JOIN pump3 ON `pump3`.owner=date.id
WHERE date.date = (Required date is here)
GROUP BY pump1.id,date.id
http://animalliberation.tk http://veganismus.ch
http://maqi.de http://tierrechtskochbuch.de