Then the records are not identical. I suggest you figure out WHY you are getting duplicated records in the DB and fix that.
I don't use MySQL or the MySQL queries so I can't help you directly with this, other than to say, find the cause of the problem rather than trying to fix the symptom.. Peter On Mon July 28 2003 21:37, you wrote: > I check everything you can imagine... > > used distinct, etc... > nothing works! > > > On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote: > > > Hello All, > > > > > > I a program in Java to read the logs recorded in MySQL DB > > and > > > > then make the billing for each customer's calls. > > > > > > I have faced a big problem that is: When I list the record > > s > > > > from the table radacct or even if I use two table (one for > > > start and another for stop) I find a lot of duplicated > > > registers which makes my Billing incorrectly. > > > > > > How can I select (using SQL) just the unique records to se > > e > > > > how many calls and to calculate the total time each user h > > as > > > > used??? > > > > > > Thanks for your time > > > Daniel > > > > Postgres has a UNIQUE keyword, not sure about MySQL.. > > > > -- > > > > Peter Nixon > > http://www.peternixon.net/ > > PGP Key: http://www.peternixon.net/public.asc > > > > > > - > > List info/subscribe/unsubscribe? See http://www.freeradius.o > > rg/list/users.html > > > > --- > Acabe com aquelas janelinhas que pulam na sua tela. > AntiPop-up UOL - � gr�tis! > http://antipopup.uol.com.br -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
