-----Original Message----- From: Kevin [mailto:lists at irubin.com] Sent: Wednesday, October 16, 2002 12:36 PM To: Thelist Subject: [thelist] mysql question > Can these be combined to return results from both tables? select item_id from tableA WHERE item_review='$search_term'; union select item_id from tableB WHERE description='$search_term';