[SQL] Records exactly the same.

[Fons Rave]

I'm writing a program in Delphi.
In SQL I'm a beginner.

I have a file in which there are records with what people have done. In the file
are records with name, date, what they have done, time-length, etc. It is
possible that there are two records that are exactly the same (somebody has done
the same, on the same day for one hour). If I use a SELECT with GROUP on a list
with some records that are exactly the same, only ONE of the identicals is
shown. But I want to see them all.

It probably is possible; but how ?

Thanks,
Fons.
[EMAIL PROTECTED]




---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Re: Records exactly the same.

[Fons Rave]

> Well, there isn't an easy answer for you ... because you've designed
> your database wrong.  Records should *never* be the same.  That is, ni
> fact, one of the cardinal rules of Relational Database Design.

Well, I started with "I'm a beginner". But I'm sure there's no reason NOT to
accept two records that are exactly the same. In the example I gave, it is clear
that the information I want to store can contain two records that are exactly
the same; doing the same thing, on the same day, for the same amount of time. In
this case it is the technical structure that doesn't want it like that. So I
have to change it to make it work.

Fons.
[EMAIL PROTECTED]




---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly