Questions tagged [inner-join]
A database operation that combines the values of 2 tables based on a condition, or relationship, that exists between those tables.
inner-join
6,683
questions
-3
votes
0
answers
31
views
Updating value in one table based on whether values (in a different column) match those in a separate table (using INNER JOIN?) [closed]
Table mailinglist has column for email addresses address and column bounced which defaults to 0. My email script will email all addresses with a 0 and ignore those with a 1 in the bounced column.
...
-1
votes
0
answers
6
views
How can I merge two data sets with the same column names to format perfectly into a single data chart?
merge(Divvy_Trips_2019_NEW,Divvy_Trips_2020_Q1,by=c("start_time","end_time","start_station_name","start_station_id","end_station_name","...
0
votes
1
answer
62
views
Hash and merge join never finishes, loops does
I ran into issues with one query that used to work fine in the past, but now it is so slow so it basically never finishes (perhaps in some hours, beyond any timeouts).
The query is like
select ky....
-1
votes
1
answer
48
views
How to fetch uncommon data from two different tables in Oracle SQL (query A - query B)
I have two select queries, where query A has all the data and I have another query with some data. We need to fetch the uncommon data from both query records. Let's say (query A - query B).
Please ...
0
votes
1
answer
41
views
Why inner join creates new distinct values in other column?
I make SQL-queries in Hive using Hue. When I use inner join between two tables, one of the table's column get new distinct values, that wasn't in this column before join.
I have table periods with ...
1
vote
2
answers
36
views
How to merge range within a range two dataframes
My brain is not braining and I can't figure out how to merge two dataframes for a range within a range. I hope you can help me.
df1 <- data.frame(
type = rep("A", 6),
start = c(66, ...
0
votes
0
answers
31
views
Rails Active Record Relations: merge different active record relations with the same classname
Suppose I have the following models (among others)
class Child < ApplicationRecord
belongs_to :parent1, class_name: "Parent"
belongs_to :parent2, class_name: "Parent"
...
-5
votes
1
answer
73
views
How do I write a query for inner join [closed]
I want to write a select query that shows me first_name, last_name and the management_name. Each employee row has a management column, which is equal to the employee_id of the manager.
This is what I ...
0
votes
1
answer
42
views
Join 2 data frames using grep
Consider the following, I have 2 data frames meta_df and data_df.
meta_df has an ID column, and data_df has another ID column which contains meta_df ID.
They can be created like this:
set.seed(123)
...
0
votes
2
answers
83
views
how to use sql innerjoin of two columns criteria from one table in an MS access database
I'M Trying to use sql innerjoin of two columns criteria from one table in an MS access database And I only want one sql query.
Please Guide Me
Thanks
SELECT PERSON.IDPERSON, MASTERPERSON.PERSONNAME, ...
0
votes
0
answers
15
views
Is watermark needed for the interval join
I am new to Flink and Stream.
I am about to perform an interval join between two streams. I got those stream data from kinesis. And I saw examples of setting a watermark for the interval join. I am ...
0
votes
0
answers
25
views
How to use INNER JOINS in Update query in IBM Data Studio
Hi I am trying to update the tables using the below query which has joins, but IBM Data studio is not accepting the JOIN statements and saying invalid use. Can you please help me
UPDATE AVGI06....
0
votes
0
answers
18
views
Differences in Presto SQL between Join via Where clause and Inner Join [duplicate]
I want to understand the differences in Presto SQL (result-wise and performance-wise) between the following 2 queries:
SELECT
table1.field1, table1.field2, table2. field3
FROM
table1
JOIN (or ...
1
vote
2
answers
48
views
Is there any way to filter based on two tables
I have a query that gets data based on multiple tables
X(id, state) has all employees with state enabled/disabled
Y(id, state) has all groups (of employees) with state enabled/disabled
A(id) ...
1
vote
1
answer
43
views
Delete from same table using inner join seems to be failing (both records removed)
I have a table which has both ChildID and ParentID. Due to the way the data was compiled, in some cases those values are reversed. So I wrote what I thought was a simple Inner Join where both values ...