Basic SQL Query question

Question

Basic SQL Query question

jjevans

SSC Enthusiast

Points: 124
More actions
March 28, 2024 at 8:07 pm

#4404022

Hello,
I was given this SQL question and was hoping someone could please help me understand the query? Thank you, J
SQL CONCEPT 1 Please write the result for the following query Table1 name 1.
A 2. B 3. C Table2 name 1. B 2. C 3. D Select t1.name, t2.name FROM Table1 t1 INNER JOIN Table2 t2 ON t1.name = t2.name
April 1, 2024 at 12:07 pm

This was removed by the editor as SPAM
April 24, 2024 at 6:38 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63503 More actions · Answer 1

What's to understand?

INNER JOIN removes records from the result set where no matching values exist on both sides of the join. So t1.Name and t2.Name will never have null values in your result, because that's what an INNER join does as opposed to an OUTER join.

jjevans SSC Enthusiast Points: 124 More actions · Answer 2

Thank you I appreciate your insight. So the result would be A? since it is not null and since the matching values were removed? And the remaining value for Table 1 is A / The remaining value for Table 2 is D.

This reply was modified 7 months, 4 weeks ago by jjevans.
This reply was modified 7 months, 4 weeks ago by jjevans.
This reply was modified 7 months, 4 weeks ago by jjevans.
This reply was modified 7 months, 4 weeks ago by jjevans.

Jonathan AC Roberts SSCoach Points: 18354 More actions · Answer 3

from ChatGPT

Query Explanation

Given Tables:

Table1	Table2
A	B
B	C
C	D

SELECT t1.name, t2.name
  FROM Table1 t1
 INNER JOIN Table2 t2
         ON t1.name = t2.name

Breakdown:

Select Statement: The command SELECT t1.name, t2.name specifies that the output should include the name columns from both Table1 (aliased as t1) and Table2 (aliased as t2). The output columns will show identical values in each row where there is a match.
From Clause: FROM Table1 t1 indicates that the data retrieval starts from Table1, which is referred to as t1 in this query.
Inner Join Clause: INNER JOIN Table2 t2 tells the database to combine rows from both Table1 and Table2 wherever there's a match, based on the condition specified in the ON clause.
On Clause: ON t1.name = t2.name is the condition for joining. It specifies that the join should occur where the name column in Table1 matches the name column in Table2.

Result of the Query:

t1.name	t2.name
B	B
C	C

Each row shows a pair of names that exist in both tables, indicating successful matches based on the conditions set by the INNER JOIN.

This reply was modified 7 months ago by Jonathan AC Roberts. Reason: reformatted

Jonathan AC Roberts SSCoach Points: 18354 More actions · Answer 4

Jonathan AC Roberts

SSCoach

Points: 18354

April 24, 2024 at 10:00 am

#4414906

deleted, duplicate

smithloo SSC Veteran Points: 268 More actions · Answer 5

thanks Jonathan for great instructions

I'm Smithloo, working for web development company