Re: "Sending data" status

2001-03-21 Thread Gerald L. Clark
You are joining 5 tables with an OR on only two relations. Give it a year !! Surat Singh Bhati wrote: > > If I run the following query , mysql server process hangs forever and > it shows the "Sending data" status. > > select Count(*) from > Registration,Ca

"Sending data" status

2001-03-20 Thread Surat Singh Bhati
If I run the following query , mysql server process hangs forever and it shows the "Sending data" status. select Count(*) from Registration,Candidates,CompanyJobs,Resumes,CandQual where CompanyJobs.qualcode=Candidates.qualcode or CompanyJob