Questions tagged [join]
A SQL JOIN clause combines records from two or more tables in a relational database.
92 questions
1
vote
1
answer
64
views
Find offers that can be matched with bids
I am working on a sql query for the following scenario:
Get all available offers for registered demand (offers from profiles
should not be from profile which had registered demand). After that
get ...
- 121
0
votes
2
answers
576
views
Simplifying the array of objects with comma separated values
Looking a way to reduce the below code to get comma separated values from the list of arrays
By using ECMA or plain old vanilla JS. How should we achieve this?
Actual Array Data:
...
- 205
-1
votes
1
answer
35
views
SQL JOIN QUERY with more than one items in common: Find the franchise pairs that operate together in more than one location [closed]
I have a table called dfmt that lists the location, revenue and franchise. I want to find the franchise pairs that operate together in more than one location.
So far, I have a query that finds the ...
- 1
3
votes
2
answers
214
views
Keeping only maximum date rows in a group
The following SQL code keeps only the MAX(date) rows with the same id and question values. I would like to know if there is a simpler/ shorter syntax returning the same result.
...
- 143
3
votes
1
answer
115
views
Flask Database Design with ORM
I am designing a Stock Currency application and for that, I created a database.
I searched for my question here first but the answerer told me to ask the same question here.
...
- 141
2
votes
0
answers
1k
views
Spark Scala: SQL rlike vs Custom UDF
I've a scenario where 10K+ regular expressions are stored in a table along with various other columns and this needs to be joined against an incoming dataset. Initially I was using "spark sql rlike" ...
- 43
4
votes
1
answer
91
views
Finding optimal mapping patterns that transform relational data into a linear format
I'm trying to upgrade my javascript to be more functional. I have used function composition and curry successful on less complicated code but i'm now running into a point where i'm not sure on how to ...
- 115
6
votes
1
answer
977
views
Update join table using list of checkboxes in Rails
I have Gig and Singer Active Record models (standard--no customization just yet) with a many-to-many relationship through a ...
- 895
2
votes
1
answer
104
views
Join and pivot multiple tables of securities data in MySQL
I'm interested in a way to join three (or more) tables in a way that is more efficient (both in terms of conciseness of code and in terms of generating the results) than what I have currently.
...
- 123
1
vote
1
answer
789
views
3
votes
1
answer
69
views
Python script to find employees who are in one PostgreSQL table but not in another
I'm writing a python script and do database query to get the ids of employees who are in one table but are not in another. I'm using psycopg2 module for python 2 and PostgreSQL as database. After ...
- 433
4
votes
1
answer
243
views
SQL query to count loans issued during each week
Calculate the number of loans issued by the Regional offices for each business week in the period from 38 to 40 business week of 2011 inclusive. Sort by name of the regional unit, business week.
...
- 193
5
votes
1
answer
59
views
Merging client names into orders using RxJS
I have an API which I can't modify. I have to use data as it is.
I want to join data from two separate requests where the second request is based on data from the first one.
I have a working ...
- 151
1
vote
1
answer
85
views
Query to generate payroll based on attendance for a month
I have written a query to generate payroll based on attendance for a month, for about 4000 employees. It takes quite a long time to execute. Basically, what I am doing is to joining two different ...
- 23
3
votes
2
answers
434
views
VBA code to import data, doing lookups to detect duplicates
I have an import macro, which creates ID by concatenating cells, then I compare using VLOOKUP with another sheet if any duplicate found.
It's running very slowly, so I want to know better ways to ...
- 31