SHOWING DISTINCT COLUMN [message #220280] |
Tue, 20 February 2007 00:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ataufique
Messages: 79 Registered: November 2006
|
Member |
|
|
I have a form in which i have a non distinct column call code.
i.e say code='A' has six rows(12 other columns)...
Now in my form i need show distinct records for code(1 row) and below that six rows(12 other columns)...
Help needed is how can i show distinct code and below 6 rows..
|
|
|
|
Re: SHOWING DISTINCT COLUMN [message #220534 is a reply to message #220490] |
Wed, 21 February 2007 02:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Using master-detail, perhaps? Master block would select DISTINCT code values, while detail would show the rest (those 12 records you mentioned).
|
|
|