Stack Overflow
Stack Overflow

Questions tagged [full-outer-join]

A full outer join combines the effect of applying both left and right outer joins.

Conceptually, a full outer join combines the effect of applying both left and right outer joins. Where records in the FULL OUTER JOINed tables do not match, the result set will have NULL values for every column of the table that lacks a matching row. For those records that do match, a single row will be produced in the result set (containing fields populated from both tables).

279 questions
-1
votes
1 answer

Full Outer Join not flagging errors with incorrect output in Oracle

I am trying to implement a full outer join query that displays all customers and staff and their sum of all their purchases. It is running without throwing any errors, however, the aggregate sum function isn't working. Only the N/A is being printed,…
lnjblue
  • 140
  • 1
  • 13
-1
votes
2 answers

Full outer join linq using union

I have two lists var left={[ID=1,Name='A',Qty1=0,Qty2=5],[ID=2,Name=B,Qty1=0,Qty2=52]}; var right={[ID=1,Name='A',Qty1=57,Qty2=0],[ID=2,Name=B,Qty1=84,Qty2=0]}; var outer=left.union(right); I want to get the following…
decoder
  • 886
  • 22
  • 46
-2
votes
2 answers

FULL OUTER JOIN Not Working As Expected ON Two Equalities

I want to combine the two tables below in Big Query using a full outer join. Table A does not have certain products that I need to bring over from table B, but when I join on campaign & subcampaign, my join is not bringing over the 'CellPhone' data.…
smoking_crab
  • 1
  • 1
-2
votes
1 answer

Creating a full join in SQL without duplicates

I have two tables, both of which have a date field. What I want as an end result is a table of dates (can be duplicated) with records A and B in that row. id_a date_a 1 Jan 1 2 Feb 2 3 Feb 2 4 Mar 3 id_b date_b a…
Dave
  • 5
-2
votes
1 answer

SQL query to choose row between duplicate value of column based on other column

I have two table Name as 'ApplicationRoles' and 'FormSchema'. I have to select result based on passing Tenant column like -'A' or 'All' -'B' or 'All' -'C' or 'All' and so on. Now i have to get result by joining both table based on below…
cj devin
  • 1,045
  • 3
  • 13
  • 48
-2
votes
1 answer

Query regarding Full outer join

I have two tables and joining them using full outer join. Tab1: Crossswalk Ind name 123 Y abc Tab2: Crosswalk Ind name 123 Null abc 123 Null bcd select coalesce(a.crosswalk,b.crosswalk), a.Ind, coalesce(a.name,b.name) from…
Mohan Babu
  • 1
  • 1
-2
votes
2 answers

T-SQL Full Outer Join Statement not including unique values from joined table

I have a T-SQL statement that is supposed to do a Full OUTER JOIN. I'll call the original select statement table1, I'll call the joined table table2. My query is not returning values that are unique in table2 . More specifically, it is not…
Jar
  • 1,766
  • 1
  • 21
  • 27
-2
votes
2 answers

Outer Join on multiple tables

select table3.tid, table3.name, talble4.name1, table4.name2 from table3 left join (select table1.tid, table1.name as name1, table2.name as name2 from table1 left join table2 on table1.tid = table2.tid union select table2.tid, table1.name,…
Udit
  • 1,037
  • 6
  • 11
-3
votes
3 answers

Combining only few columns to 1 in SQL

I have 2 tables tbl1, tbl2. Sample data of tbl1: Id Name CreatedOn SpentAmt 1 abc 2023/03/31 1000 2 Test 2023/03/31 14000 3 Mark 2023/03/31 2000 4,5 Robert,Gustin 2023/03/31 700 Sample data of…
Test
  • 13
  • 4
1 2 3
…
18
19