Hi all, Just jumped on the list, hoping someone can give me a hand. The query below uses a join, I guess, to select records from table stat_1_1 based on information in table stat. I'd like to be able to turn this query into a delete query but only want records removed from stat_1_1. Can anyone tell me how? I must be missing something really obvious.
Thanks, Chuck Mayo SELECT DISTINCT stat_1_1.event_id FROM stat_1_1, stat WHERE stat_1_1.player_id=39 && stat_1_1.stat_id = stat.id && stat.stat_group = "Individual" --------------------------------------------------------------------- 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