thanks for taking the time to look best
bill -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 20:19 To: [EMAIL PROTECTED] Cc: Bill - compuserve Subject: Re: select count from three tables * Bill - compuserve > Thanks for the suggestion but unfortunately this seems to produce the > product of the two tables `lghyperlink` and `lgsearch`. Yes, sorry about that. [...] > Any other suggestions gratefully received - maybe this has to be > done in two queries and the data manipulated in the application: > less than ideal but if there is no other way... I have done some experimenting, but I have not found any better ways. Luckily it is relatively easy to do it in the app. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]