Hi, I would try: Select email >From table2, table3 Where table3.emailID = table2.emailID And id = "1" This should give you bill@xxxxxxxxxxx bill@xxxxxxxxxx bill@xxxxxxxxx FG -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php