Top "Full-outer-join" questions

How to do a full outer join without having full outer join available

Last week I was surprised to find out that sybase 12 doesn't support full outer joins. But it occurred to me …

sql sap-ase full-outer-join

SQLite3 Simulate RIGHT OUTER JOIN with LEFT JOINs and UNION

I have the following select statement where I need to sum each task from table tbTasks and group them by …

sql sqlite group-by union full-outer-join

SQL Full Outer Join on same column in same table

This may be more of a design issue than anything, but I'm hoping it's possible without too much voodoo. Suppose …

sql oracle full-outer-join

Full outer join not returning all rows?

I have a table that contains multiple records for multiple dates. I am trying to see the difference between "date 1" …

tsql full-outer-join

Performance Comparison: Full outer join vs Union, Union All

I have tables named: mktActualsales (SaleID, EmployeeID, PeriodID,PositionID) mktActualSalesItems(SaleItemID, saleID, Item, Quantity) mktSalesTargets(TargetID, EmployeeID, PeriodID,PositionID) mktSalesTargetItems(…

sql sql-server-2008 union full-outer-join

Why does full outer join in HIVE gives weird result when one of the join fields is missing?

I'm comparing the behavior between SQL engines. Oracle has the behavior I would expect from a SQL engine for full …

hadoop oracle11g null hive full-outer-join

How to do full outer join to combine two tables in mysql?

I have two tables payroll_advance and payroll_advrtn,and i supposed to do full outer join to get my …

mysql join full-outer-join

how to do a full outer join that will populate with their joing criteria regardless if they don't match up

I have two tables I'm doing a full outer join on. They are joined on variable "accsnnum", which they both …

sql join sas full-outer-join