Hi Irina,
Thanks a lot for your reply. And yes, in my case it helped. So I'm very grateful.
It wasn't totaly the correct solution, but it helped me to fnd the solution, which is:
SELECT MAX(p.Modifdatu m) AS modifdatum, MAX(OTCUser.che cklistcomm.comm ) AS comm, p.Status, p.station, MAX(p.checkitem ) AS Expr1
FROM OTCUser.checkli ststat p INNER JOIN
OTCUser.checkli stcomm ON p.Checknr...
whoops
Last Activity: Dec 7 '07, 10:49 AM
Joined: Oct 10 '07
Location: Belgium - Reet (Antwerp)
-
Thanks for quick reply, but ... nope, unfortunately. I tried with where but had the same results.
SELECT MAX(p.Modifdatu m) AS modifdatumv, OTCUser.checkli stcomm.comm, p.Status, p.station, p.checkitem
FROM OTCUser.checkli ststat p INNER JOIN
OTCUser.checkli stcomm ON p.Checknr = OTCUser.checkli stcomm.checknr
WHERE (p.Status = '2') AND (p.station = '00BE104740')
GROUP BY p.station,...Leave a comment:
-
Remove Fields From results from Innerjoin In Sql
Hi, I' ve been struggling for a few days with following problem.
I have a query with 2 tables (below). They are joined by one key field checknr.
I would only like to see field comm from table OTCUser.checkli stcomm, but only the last result which are conform to the condition. So the fields in black shouldn't appair.Could someone help me ?
SELECT MAX(p.Modifdatu m)...Leave a comment:
-
Remove Fields From results from Innerjoin In Sql
Hi, I' ve been struggling for a few days with following problem.
I have a query with 2 tables (below). They are joined by one key field checknr.
I would only like to see field comm from table OTCUser.checkli stcomm, but only the last result which are conform to the condition. So the fields in black shouldn't appair.
Can someone help me ?
SELECT MAX(p.Modifdatu m) AS modifdatumv, OTCUser.checkli stcomm.comm, p.Status,...
No activity results to display
Leave a comment: