MySQL'de İki Tablo'dan Veri Çekme

SELECT content.*,polls.* FROM (SELECT c.id as 'contentID', c.title as 'contentTitle',c.username FROM forum_content as c WHERE c.username='{$user->username}') as content INNER JOIN (SELECT p.id as 'pollsID',p.title as 'pollsTitle',p.username FROM forum_polls as p WHERE p.username='{$user->username}') as polls ON content.username=polls.username

SELECT c.*,(SELECT p.id as 'pollsID',p.title as 'pollsTitle',p.username FROM forum_polls as p WHERE p.username='{$user->username}') as polls FROM forum_content WHERE c.username='{$user->username}')

ezSQL (v2.03) Variable Dump..

Array
(
    [0] => Array
        (
            [contentID] => 7
            [contentTitle] => Tanışalım
            [username] => Administrator
            [pollsID] => 1
            [pollsTitle] => Yeni Sitemiz
        )

    [1] => Array
        (
            [contentID] => 169
            [contentTitle] => Video istek
            [username] => Administrator
            [pollsID] => 1
            [pollsTitle] => Yeni Sitemiz
        )

    [2] => Array
        (
            [contentID] => 170
            [contentTitle] => Program İstek
            [username] => Administrator
            [pollsID] => 1
            [pollsTitle] => Yeni Sitemiz
        )

    [3] => Array
        (
            [contentID] => 171
            [contentTitle] => Oyun İstek
            [username] => Administrator
            [pollsID] => 1
            [pollsTitle] => Yeni Sitemiz
        )

)


Type: Array
Last Query [17]: SELECT content.*,polls.* FROM (SELECT c.id as 'contentID', c.title as 'contentTitle',c.username FROM forum_content as c WHERE c.username='Administrator') as content INNER JOIN (SELECT p.id as 'pollsID',p.title as 'pollsTitle',p.username FROM forum_polls as p WHERE p.username='Administrator') as polls ON content.username=polls.username
Last Function Call: $db->query("SELECT content.*,polls.* FROM (SELECT c.id as 'contentID', c.title as 'contentTitle',c.username FROM forum_content as c WHERE c.username='Administrator') as content INNER JOIN (SELECT p.id as 'pollsID',p.title as 'pollsTitle',p.username FROM forum_polls as p WHERE p.username='Administrator') as polls ON content.username=polls.username")
Last Rows Returned: 4

Unknown table 'c'

Operand should contain 1 column(s)

SELECT content.*,polls.* FROM (SELECT c.id as 'contentID', c.title as 'contentTitle',c.username FROM forum_content as c WHERE c.username='{$user->username}') as content INNER JOIN (SELECT p.id as 'pollsID',p.title as 'pollsTitle',p.username FROM forum_polls as p WHERE p.username='{$user->username}' GROUP BY p.id) as polls ON content.username=polls.username

SELECT forum_content.id,forum_content.title,forum_polls.id,forum_polls.title
FROM forum_content LEFT JOIN forum_polls
        ON forum_content.username=forum_polls.username /* Burada İlişkili Olduğu Colomlar Yazılır*/
WHERE forum_content.username='MEHMET'