Considering only basic relational algebra operations, how can we implement the full outer-join ?
$\begingroup$
$\endgroup$
2
-
$\begingroup$ A simple google search yields this $\endgroup$– SagnikCommented Feb 16, 2018 at 6:29
-
$\begingroup$ @Sagnik well, I need to ignore any type of join and only consider basic operations (the solution comes with inner join). $\endgroup$– fhmCommented Feb 16, 2018 at 13:43
Add a comment
|
1 Answer
$\begingroup$
$\endgroup$
Full outer join returns null in the columns of rows from one table that don't match the other table -- that's a description of SQL.
Standard Relational Algebra doesn't have nulls. Here explains what would be the consequences.
Short answer: 'we' don't want to implement outer joins. If you think you do, think some more until you see why it leads to incoherence of queries.