[V4MD] / [ALL] DISTINCT bug?

[Ruslan Zasukhin]

on 12/7/03 5:57 PM, Martin Kloss at martin.kloss at gmx.de wrote:

> Hi Ruslan,
> 
> I think there is a problem with selecting DISTINCT records with joined tables.
> 
> I have 3 tables: "chapters, sub_chapters, data" and I'm trying to get the
> distinct
> names of sub chapters. All records are stored in the "data" table and they
> have PTR's to the chapter and sub chapter tables (chapter_ptr,
> sub_chapter_ptr).
> So here's the query to get a list of sub chapters for all records in a
> chapter:
> 
> SELECT DISTINCT sub_chapter_name FROM chapter, sub_chapter, data
> WHERE chapter_name = 'First Chapter' ORDER BY sub_chapter.RecID ASC
> 
> The problem is that I get a list with all sub chapter names for each record,
> but the list is not unique so the DISTINCT option did not really work.
> It's the same in VAPP and VStudio, so it's not a V4MD bug.
> Or am I missing something here?

Hi Martin,

Can you send me your database with few records,
And SQL query.

I will test from viSQL.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------