Stack Overflow
Stack Overflow

Questions tagged [outer-join]

An outer join defines a relationship between two tables where all records from one or both tables are returned regardless of the existence of a matching key-field in the other table. A full outer join combines the results of both tables. A left or right join returns all the records from the first or second specified table, respectively. NULLS are filled in for matches on either side. A self-join compares a table to a copy of itself.

A full combines the results of both tables. A left or right returns all the records from the first or second specified table, respectively. NULLS are filled in for matches on either side. A compares a table to a copy of itself.

References

1671 questions
4
votes
1 answer

Pandas: outer product of row and col sums

In Pandas, I am trying to manually code a chi-square test. I am comparing row 0 with row 1 in the dataframe below. data 2 3 5 10 30 0 3 0 6 5 0 1 33324 15833 58305 54402 38920 For this, I need…
Zhubarb
  • 11,432
  • 18
  • 75
  • 114
4
votes
4 answers

Merge df1, df2, df3 dataframes in R on a specified column

In R, I have df1, df2, and df3 that represent lightning storms. Each df has two columns, 'city' and 'injuries'. df1 = data.frame(city=c("atlanta", "new york"), injuries=c(5,8)) df2 = data.frame(city=c("chicago", "new york"), injuries=c(2,3)) df3 =…
Andrew Heekin
  • 671
  • 1
  • 6
  • 15
4
votes
2 answers

Joining tables with records that might not exist

So I have these following tables that are causing me a bit of a headache. What I want to do is to create a query that returns all assignments for a given course with a assignment info (grade, average grade etc.) or just null in those fields if the…
Bjarki
  • 221
  • 1
  • 4
  • 11
4
votes
2 answers

Prevent NULL checks in LINQ to Entity Joins

We have a table called Student. That table has a field called Homeroom, where the value is a room number of the student's homeroom. The value can be null. We have a second table called Staff. That table also has a field called Homeroom to…
scott.korin
  • 2,537
  • 2
  • 23
  • 36
4
votes
2 answers

SQLite Left Outer Join not working as expected in Android

I have prepared a left outer join query that should be returning non-null data when a record exists in my BLOB table that matches keys with a record in my INCIDENT table. Essentially, the data and query looks like this: Table A Key Table B …
user2835813
  • 41
  • 1
  • 2
4
votes
3 answers

How do I perform an outer join with a JPA CriteriaBuilder query?

I'm using JPA 2.0, Hibernate 4.1.0.Final, and MySQL 5.5.27. I want to construct a JPA query that will return two entities per row and I want to perform a right outer join. The two entities are: @Entity @Table(name = "user", uniqueConstraints =…
Dave
  • 15,639
  • 133
  • 442
  • 830
4
votes
1 answer

Using outer joins in HQL queries

I'm trying to build a query using HQL and OUTER JOINs and just can't get it work. Consider the following mapping …
msp
  • 3,272
  • 7
  • 37
  • 49
4
votes
1 answer

SQLAlchemy convert outer join ORM query to Core

I'm having problems with SQLAlchemy's select_from statement when using the core component. I try to construct an outer join query which currently looks like: query = select([b1.c.id, b1.c.num, n1.c.name, n1.c.num, ...] ).where(and_( …
orange
  • 7,755
  • 14
  • 75
  • 139
4
votes
1 answer

How to access joined record from Rails LEFT OUTER JOIN

Howdy I found plenty of examples on how to use LEFT OUTER JOIN, but I can't seem to find a way to access what I have joined. Here is what I mean: List.featured. joins( "LEFT OUTER JOIN follows ON ( follows.followable_id = lists.id AND …
hakunin
  • 4,041
  • 6
  • 40
  • 57
4
votes
3 answers

Creating nonsense words - using outer() with three+ dimensions in R

I am creating nonsense words given lists of first consonant, vowel, final consonant: initial_consonants <- c("r", "w", "h", "sp", "st", "sk") vowels <- c("i", "u", "I", "U", "E", "V", "@") final_consonants <- c("f", "ts", "rS", "rv", "rl", "Dz",…
Annemarie
  • 689
  • 6
  • 14
  • 28
4
votes
3 answers

outer join in MS Excel

do you have an idea how to join two tables with the outer join ? Know to do this in SQL, but I need Excel now. I have a list of all employees in one column I have a table of task for every employee. I would like to create a function, that will…
user2127956
  • 49
  • 1
  • 1
  • 3
4
votes
4 answers

MySQL Counting unique values over two columns and joining those counts for each column

I have a table that is setup like this: +----+-------+-------+ | id | col1 | col2 | +----+-------+-------+ | 1 | John | Mike | | 2 | Mike | John | | 3 | Marty | John | | 4 | Walt | Marty | | 5 | Walt | Mike | …
Leroy
  • 544
  • 3
  • 14
4
votes
1 answer

How to exclude duplicate rows when joining a table with itself

Here's a sample table to help illustrate my problem: mysql> select * from test; +----+--------------+--------+ | id | type | siteid | +----+--------------+--------+ | 1 | First Visit | 100 | | 2 | Second Visit | 100 | | 3 | First…
Rob Thomas
  • 686
  • 7
  • 17
4
votes
4 answers

How to propagate exception from thread in java?

Code: outerMethod { @Override public void run() { innerMethod throws IOException } } Method that exceuted in thread throws checked exception - IOException. I need to handle this exception in…
user710818
  • 23,228
  • 58
  • 149
  • 207
4
votes
1 answer

In MySQL, how to select empty records

I have the following MySQL Table Structure: mysql> desc customers; +---------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra…
ILikeTacos
  • 17,464
  • 20
  • 58
  • 88
1 2 3
…
99 100