Hi, I'm having intermittent problems with a big query where I grab about 30 fields from 4 tables.
I've snipped my query: Select ... Status_Msg from Extracts, Transacts, Publisher, Status where ( Transacts.ID=33237 and Extracts.Pub_ID=Publisher.ID and Transacts.Status=Status.ID and Transacts.Extract_ID=Extracts.ID) It works sometimes, but not always. Can anyone suggest a more efficent way (that works) to do this? Cheers George in Oxford -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]