Stack Overflow
Stack Overflow

Questions tagged [right-join]

The RIGHT JOIN keyword will return all the rows from the right table, even if there are no matches in the left table.

SQL RIGHT JOIN ON returns the rows of INNER JOIN ON plus unmatched right table rows extended by NULLs. A consequence is that it returns all the rows from the right table at least once even if there are no matches in the left table. See examples here.

233 questions
0
votes
2 answers

Yii2 right join only returning 2 columns

Working on an API and I have this query: $query = CallerIdentity::findNonGeo()->join( 'RIGHT JOIN', 'ehadata', 'caller_ids.cidref = ehadata.cidref') ->select('ehadata.*') ->where(['caller_ids.cidref' => $id]); echo…
Kyle
  • 667
  • 6
  • 28
0
votes
1 answer

Right join / inner join / multiselect [MYSQL] TABLE RESULTS

I have a big trouble to find a correct way to select a column from another table, and show one results that would contain two tables in the same time. First table: id | times | project_id | 12 | 12.24 | 40 | 13 | 13.22 | 40 …
Valerius Romulus
  • 55
  • 8
0
votes
1 answer

Joining tables with a many to many relationship

assuming these 3 tables: student - | student_id | name | sex | - 31 students score - | event_id | student_id | grade | - 173 total grades event - | event_id | type | date | - 6 events this means there could be a total of 186…
Mike
  • 632
  • 7
  • 22
0
votes
1 answer

Using ight join and inner join in Access

I want to use inner join and right join statement. This is the relation of my tables. I'm trying but it says join statement is not supported. Here's my code: SELECT ProjectName, HoursWorked, FirstName, LastName FROM (PROJECT AS P INNER JOIN…
Yoo Inhyeok
  • 101
  • 1
  • 2
  • 9
0
votes
1 answer

Replacing nested SELECT

How can I make postgreSQL query like this: SELECT event_id, user_id FROM public."point" WHERE user_id = (SELECT id FROM public."user" WHERE email='test@gmail.com') with JOINstatement and without nested SELECT statement. Above works but I think it…
MattCodes
  • 489
  • 8
  • 21
0
votes
2 answers

sql right join return multiple rows from right table

I have two tables products table and batch table. products table contains a list of products and batch table contains information on arrival date, expiry date, batch number and quantity. when recording to batch table i pull product_id and store it…
Njoroge Mathu
  • 45
  • 6
0
votes
1 answer

Data wont insert into table using insert into and right join

I'm trying to insert the result of a Right join into column CATO_NAME of table deal_classification_DM I created. The result of the select is what I expect and the program run's fine, but data is not updated into the table. What's wrong? `INSERT INTO…
P_Sta
  • 55
  • 1
  • 10
0
votes
2 answers

MYSQL: Limiting rows per whereIn()

users Table id user_comments Table id | user_id | content | created_at I have a list of user IDs, and I want to grab the latest 3 comments for each user id. SELECT * FROM user_comments WHERE user_id IN (1, 2, 3, 4, 5) ORDER BY created_at…
magnito
  • 133
  • 7
0
votes
2 answers

List all employees and the number of people they supervise in mysql

I have a table of employees. Each employee has an employee id. Some employees have a supervisor field that links back to another employee's id. There are 10 employees, two of which are supervisors, each supervising 4 people. I am trying to get a…
user2328273
  • 868
  • 3
  • 12
  • 22
0
votes
2 answers

Extract Specific Data After a aggregation (Or any other solution for the desired result)

I want to select the Total "sales" of a specific "main_category" for the year 2016 (main categories that don't have sales in that year should appear as zero) I have managed to select the "sales" of a specific "main category" with all the other…
Daniyal Nasir
  • 669
  • 7
  • 22
0
votes
1 answer

PHP RIGHT JOIN query not considering null?

When I run the query it returns all the correct values except it doesn't return any values where a.Correct = null (i.e a quiz question hasn't been answered at all), but it does return values for a.Correct = 0. /***Configure the retest***/ …
Kurt Görg
  • 15
  • 3
0
votes
1 answer

right join on my linq query

I want to return ALL items from db.Accounts. How do I do a right join on the below linq query? var query = ( from tradeTbl in db.Trades join acctTbl in db.Accounts on tradeTbl.AccountID equals…
solarissf
  • 1,199
  • 2
  • 23
  • 58
0
votes
2 answers

Make one-to-one relation between two tables that have one-to-many relation in SQL

I have these queries : SELECT dbo.Lines.Unit, dbo.Lines.LineNumber, dbo.Lines.DocumentNumber, dbo.BaseMaterials.Name AS MaterialName, dbo.MaterialDescriptions.Name AS MaterialDescription, …
Ehsan Akbar
  • 6,977
  • 19
  • 96
  • 180
0
votes
2 answers

MS ACCESS SQL Join Subquery

I have two tables: newparts, storedparts I insert the parts of the newparts, which are not jet in the storedparts into the storedparts: SQL_String = "INSERT INTO storedparts " & _ "SELECT newparts.* " & _ "FROM storedparts…
G-hut
  • 5
  • 4
0
votes
1 answer

Do not know how to retrieve information with RightJoin on CakePHP 3.2

CakePHP Version: 3.2 Platform and Target: Wamp, MySQq, Google Chrome What I did Right Join between two tables in one controller. I'm trying to retrieve the information and I can't $query = $this->Schedules->find('all') ->rightJoin(['Sessions'=>…
teph
  • 23
  • 4
1 2 3
…
15 16