Outer Join Giving Fatal error

Asked Oct 13 '15 at 11:21

Active Oct 13 '15 at 11:54

Viewed 53 times

I have a two table table_a and table_b , table_a has a field a and table_b has a field b.

I have been written below sql & php code

$query  =  "select * from table_a FULL OUTER JOIN table_b on table_a.a = table_b.b";
$result = $conn->query($query);
while($row = $result->fetch_assoc()){   //this is 38 number line
        echo "<pre>";
            print_r($row);
        echo "</pre>";
}

It's giving me below error

Fatal error: Call to a member function fetch_assoc() on a non-object in C:\xampp\htdocs\sql\index.php on line 38

I am not finding any error here. If I use inner join here it's showing me result correctly.

edited Oct 13 '15 at 11:54

Your Common Sense

154,967
38
205
325

asked Oct 13 '15 at 11:21

Satu Sultana

call [mysqli_error](http://www.w3schools.com/php/func_mysqli_error.asp) to see if there are problems with your statment – Jens Oct 13 '15 at 11:24
If I use inner join it's showing result without any error. Problem only in full outer join. – Satu Sultana Oct 13 '15 at 11:25
1

MySQL doesn't support `FULL OUTER JOIN`. What results do you actually want to produce? – Gordon Linoff Oct 13 '15 at 11:31
I want to produce a = > [1,2,3,4,null,null] b=>[null,null,3,4,5,6] – Satu Sultana Oct 13 '15 at 11:37
3

You have to use `RIGHT OUTER JOIN` and `LEFT OUTER JOIN` and combine the results using `UNION ALL`. See http://stackoverflow.com/a/4796911/3647441 – mario.van.zadel Oct 13 '15 at 11:44
@mapek, did you want to suggest that as an answer to help people searching for "outer join errors"? – Nerdwood Oct 13 '15 at 12:49

Outer Join Giving Fatal error

0 Answers0