At 12:26 31.10.03 +0200, you wrote:
>Send me small db and small script that this show.,
Puh, I don't know if I find the time to create a db and a script
to simulate it, my app is huge and the db also, so it's not
easy to extract that part.
>Also I wonder, why not to use GROUP BY in your case?
Sorry, the SQL was just a simplified version of my real query
which selects records from the data table which has many more fields:
SELECT RecID, id, chapter_name, title, source......, type_name FROM
chapter, data, data_type ....
It's not to select the data types, which would of course need a
GROUP BY statement :-)
Martin.
_______________________________________________
Valentina mailing list
Valentina at lists .DOT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2003 Martin Kloss |
