Problem with the select query

Question

Hi,

I have this select query

SELECT Avtobusi.Garbr, Max(Avtobusi.Data_implem) AS MaxOfData_implem
FROM Avtobusi
where Avtobusi.Sloboden=true

GROUP BY Avtobusi.Garbr;

but this considers the Avtobusi.Sloboden first and than the max(Avtobusi.Data_implem) (it takes the rows where it is true for the certain Garbr regardless that there are rows after that with newer date with values "false" for Avtobusi.Garbr). In fact, with this query I get rows which are true for Avtobusi.Sloboden, and I want first to get the last Data_implem row for the certain Garbr (the newest date row), and if it has true (checked) value for Avtobus.Sloboden to select it, otherwise not to select it.

Caould anybody help me how to change teh select query to achive the above described.

Thanks in advance.

Answer 1

I might be wrong, but I think its because you can't read XML from a URL. Maybe your mistaking XML for XHTML, which is eXtensibile HyperText Markup Language and its what 90% of web pages are built on these days unless you get into PHP or JavaScript and what not.
XML I believe is used primarily for web data storage on a user's PC and for small and simple database-like needs, it can be read by a web page, but is not an actual part of the build source code. Then again, I could be wrong but in all my web designing in college we never once used XML for the actual code construction of web pages.

-Scrap