Try to delete the index (drop index) of the table! I had the problem and solved this this way.
regards, Andreas On Samstag, Februar 9, 2002, at 11:41 Uhr, DL Neil wrote: > Keith, > >> I have the below query that returns the correct records but the >> POINTFUND.description field is all NULL while it has values in the >> table. >> Any idea why? Thanks. >> >> SELECT >> >> RACES.RACE_ID, >> RACES.sequence, >> TYPES.typelong, >> SCHEDULE.event, >> SCHEDULE.date, >> PARTY.lname, >> POINTFUND.description >> >> FROM >> >> TYPES LEFT JOIN RACES ON RACES.TYPE_ID = TYPES.TYPE_ID >> LEFT JOIN POINTFUND ON POINTFUND.TYPE_ID = TYPES.TYPE_ID, >> SCHEDULE, >> PARTY >> >> WHERE >> >> RACES.SCHEDULE_ID = SCHEDULE.SCHEDULE_ID AND >> PARTY.PARTY_ID = SCHEDULE.TRACK_ID >> >> ORDER BY >> >> SCHEDULE.date, PARTY.lname > > > Obviously the syntax of the SQL command is ok, else the RDBMS would > have told you. The answer may lie in the > definitions of the races, types, and pointfund tables; or in the data > contained in the join-ing fields (neither > of which are shown here). > > Two suggestions: > 1 simplify the query to deal with pointfund and one other first, then > add another tbl/join, etc, until you have > rebuilt the entire query - your formatting is 'clean' and allows the > insertion of # comment symbols at the > beginning of lines to remove/return then easily (and without loads of > typing/retyping) > 2 have you tried running EXPLAIN to see what MySQL thinks of it all? > > Let us know how you get on! > =dn > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > ----------------------------------------- Andreas Habereder Kirchenstr. 17e 81675 München private: [EMAIL PROTECTED] fax: +49 1212 5 107 37 317 mobile: +49 172 838 7771 ----------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
