NiZZo_ adlı üyeden alıntı: mesajı görüntüle
Şu şekilde dene bakalım.
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
---
Yada şunu
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}')

Bu kullanıcın forum_content alanında 4, forum_polls alanında ise 1 tane içeriği var. İlk sorgu şöyle:

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
İkinci sorgu ise hata veriyor:


Bütün c yerine forum_content yazdığımda ise:

Unknown table 'c'
Operand should contain 1 column(s)