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
2 answers

Join Multiple tables with No Relation

I need to join 3 tables and there are no relations between these tables other than they all have common fields (profiledid and instanceid) For example, these 3 tables are Achievement [0 records], Attachment [6 records] and collegeattended [4…
sebeid
  • 121
  • 8
-1
votes
1 answer

Access Union Query to get Full Outer Join

I have 2 tables TestFname & TestLname. Each have some entries with first name only, some with last name only and some with both first and last names. Each Person has unique Number, so if Jack Smith occurs as "Jack" in TestFname and "Smith" in…
sleibo
  • 11
  • 3
-1
votes
3 answers

How to stop the multiplying sum of same value reptedly without entering any values in that column in SQL using full join and group by

I have two tables T1 & T2 and two same columns in both tables C1 & C2 I am doing the subtraction of sum of two columns using full join and group by but when I adding the value in T1.C2 or T2.C2 the other columns value is multiplying automatically. I…
Nagesh Rao Nemmaniwar
  • 25
  • 5
-1
votes
1 answer

Matching and unlatching records in a single table sql server

I have procedure where I am getting data from my 1st temp table like below 2nd temp table like below Now I need to join this 2 temp tables to get all matching and unmatching data .My result would be like below But I am getting only matching…
Raja
  • 9
  • 2
-1
votes
1 answer

SQL full outer join + group by + count column

I have two tables: currency_table_1 ID - currency_1 ------------------ 01 - EUR 02 - EUR 03 - EUR 04 - USD 05 - USD 06 - USD currency_table_2 ID - currency_2 ------------------ 01 - EUR 02 - EUR 04 - JPY 05 - …
Timo
  • 3
  • 1
-1
votes
4 answers

Microsoft SQL Server Conditional Joining based on 2 columns

I am looking to join 3 tables, all with the same data except one column is a different name (different date for each of the the 3 tables). The three tables look like the following. The goal is if a condition exists in table 1 AND/OR table 2…
Brad
  • 85
  • 12
-1
votes
1 answer

Full outer join like functionality but merging columns

TableA id | symbolA 1 m 2 n 4 o TableB id | symbolB 2 p 3 q 5 r I'd like the following result: id | symbolA | symbolB 2 n p 1 m NULL 4 o …
Liem Ta
  • 39
  • 4
-1
votes
1 answer

Relational Algebra- fullouterjoin

The “left outer join” operation is an extension of the relational join operation. The basic idea is that all tuples in the left relation always appear in the “left outer join” result, irrespective of whether they join with any tuple in the right…
computer_engineer
  • 1
  • 1
-1
votes
2 answers

Is there any way to make FULL OUTER JOIN table match with the correct record?

I'm trying to join two table using FULL OUTER JOIN that two table have different row of data and the column between this two table are same. Table 2 FULL OUTER JOIN Table 1 Table 1 id     name         Payment Amount === ========…
Jack Fire
  • 1
  • 1
-1
votes
2 answers

Hive Full Outer Join Returning multiple rows for same Join Key

I am doing full outer join on 4 tables on the same column. I want to generate only 1 row for each different value in the Join column. Inputs are: employee1 +---------------------+-----------------+--+ | employee1.personid | employee1.name …
user1326784
  • 627
  • 3
  • 11
  • 31
-1
votes
1 answer

how to get all the data from database from 3 tables?

My problem is, i am getting the datas which is present in all the 3 tables.But i want to display the data which is not present in any one of the table(that is empty space or 0 is printed on that item if it's not present in anyone of the table)..i…
Teddy
  • 102
  • 11
-1
votes
1 answer

Full outer join in postgres

I have the following table in Postgresql: sch_code sch_level start_date end_date flag 1234 P 01-01-2018 31-01-2018 V 1234 S 01-01-2018 31-01-2018 V 5678 S 01-01-2018 31-01-2018 …
prajakta
  • 21
  • 1
  • 8
-1
votes
1 answer

Sqlite get the average of combined two tables columns

I have the following problem which i'm not sure how to approach a solution. I have the following db schema: I want to get the median of both columns of both tables, filtered by userid, year and month. Doing this with two separate queries, i would…
richard slond
  • 180
  • 11
-1
votes
1 answer

Combine results of multiple MySQL queries (w/ Group By) on 1 table

What's the best way to do this? I'll describe below, but here is a setup at rextester.com data to play with- http://rextester.com/PXQOV60475 I have a table called "cases" that contains info on repair jobs basically. There is a field for the Case…
Michael K
  • 1,031
  • 2
  • 14
  • 27
-1
votes
1 answer

MySql Full Join

I'm using MySql So I have 5 tables and I'm trying to build a view which joins all these together and shows the missing information the current structure is. plat (1 = Many) PG (1 = Many) TS PG (1 = Many) PGHist TT (1 = Many) TS OR I am using MySql…
Alec George Doran-Twyford
  • 381
  • 2
  • 5
  • 13
1 2 3
…
18
19