从多个表和多个喜欢中选择查询

Question

I'm trying to query several tables with just one query string with no luck. I've read maybe 50 posts in here with no avail. Here's what I have so far:

$sql = "SELECT *
    FROM table1
    WHERE (id LIKE :searchterm
    OR fname LIKE :searchterm
    OR lname LIKE :searchterm)
    UNION ALL
    SELECT *
    FROM table2
    WHERE (id LIKE :searchterm
    OR lang1 LIKE :searchterm
    OR lang2 LIKE :searchterm)
    ";
try
{
    $core = Core::getInstance();
    $stmt = $core->dbh->prepare($sql);
    $stmt->bindParam(':searchterm', $this->_searchTerm);
    if ($stmt->execute()) {
    $stmt->setFetchMode(PDO::FETCH_ASSOC);
        while ($result = $stmt->fetch()) {
            print_r($result);
        }
    } else {
        echo "Couldn't get result.";
    }
} catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}

If I remove from the UNION ALL and leave just the first SELECT, it works. Any ideas?