Re: Consultation in 4 tables

2004-01-08 Thread Joao Pedro
I found what was missing. I put distinct into the 'count( )' tag then it resolve the problem. Tkz for all Joao Pedro - Original Message - From: "Joao Pedro" <[EMAIL PROTECTED]> To: "Joao Pedro" <[EMAIL PROTECTED]> Sent: Thursday, January 0

Consultation in 4 tables

2004-01-08 Thread Joao Pedro
times that appear in tables B, C and D. Therefore if it has 1 register in B, 2 in C and 3 in D. Then it appears 6 as reply in each item, being that it would have to appear 1, 2 and 3 respectively. I am thankful very if somebody will be able to help me? Best Regards, Joao Pedro -- MySQL General Ma