8 May
2012
8 May
'12
2:35 a.m.
Hi Mark
Going on a slight tangent, if a query could result in the same record multiple times you can use the DISTINCT keyword (ie "SELECT DISTINCT ... FROM ..). Of course this will only work if you're only returning data from the main record not different join data in the SELECT field set.
Commonly, perceived need for DISTINCT tends to indicate a flawed query construct. Cheers, Arjen. -- Exec.Director @ Open Query (http://openquery.com) MySQL services Sane business strategy explorations at http://Upstarta.biz Personal blog at http://lentz.com.au/blog/