rookie
|
| Posted: 09/02/2004, 9:25 AM |
|
how can I join similar rows in one, I have a view that presentes multiple rows that are exactly the same, how can I do to group them in one...?
|
|
|
 |
DonB
|
| Posted: 09/02/2004, 12:54 PM |
|
That is the function of the SELECT DISTINCT - the SQL thus selects only the
different rows, discarding the duplicates. Microsoft Access implements
SELECT DISTINCT ROW, too, which I believe checks the entire table row for
duplication, regardless of what columns are listed in the SELECT.
--
DonB
http://www.gotodon.com/ccbth
"rookie" <rookie@forum.codecharge> wrote in message
news:641374983e11fb@news.codecharge.com...
> how can I join similar rows in one, I have a view that presentes multiple
rows
> that are exactly the same, how can I do to group them in one...?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 09/02/2004, 9:09 PM |
|
Sometimes select distinct can be cumbersome when many joins are performed.
In these cases you can override the SQL and write something like:
Select t1field1, t1field2, t1field3 from table1
where exists (select t2field1 from table2 where t2field1 = t1field1) and
exists (select t3field1 from table3 where t3field1 = t1field1)
and so on.
This would show you the distinct rows equivalent to an inner join.
"rookie" <rookie@forum.codecharge> wrote in message
news:641374983e11fb@news.codecharge.com...
> how can I join similar rows in one, I have a view that presentes multiple
rows
> that are exactly the same, how can I do to group them in one...?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
