Thread: zelfde data samenvoegen
-
12-08-2010, 18:55 #1Member
- Registered
- 23/12/03
- Location
- Gent
- Posts
- 1,575
- iTrader
- 4 (100%)
- Mentioned
- 0 Post(s)
- Reputation
- 0/0
zelfde data samenvoegen
Hi,
Is er iemand die weet hoe je na een query, 2 of meer dezelfde data samen kunt nemen zodat er geen dubbele meer zijn?
thx
no votes
-
-
12-08-2010, 19:04 #2Member
- Registered
- 06/06/04
- Location
- Bilzen
- Posts
- 8,805
- iTrader
- 18 (100%)
- Mentioned
- 0 Post(s)
- Reputation
- 42/128
Even googlen op MysQL unique en ik kom al uit op MySQL :: MySQL 5.0 Reference Manual :: 7.3.1.13 DISTINCT Optimization
no votes
-
12-08-2010, 20:06 #3Approved 9liver
- Registered
- 18/01/04
- Location
- Melle
- Posts
- 10,535
- iTrader
- 56 (100%)
- Mentioned
- 0 Post(s)
- Reputation
- 27/102
Of group by, of met joins, het hangt er vanaf wat je wil bereiken.
“In terms of how we evaluate schooling, everything is about working by yourself. If you work with someone else, it’s called cheating. Once you get out in the real world, everything you do involves working with other people.”
PSN: Cycloon - Final Fantasy XIV: A realm reborn characterno votes
