topic Re: What will be the output if we do left join and Right join on the below table in New SAS User

What will be the output if we do left join and Right join on the below table

animesh123 — Sun, 02 Jul 2023 03:13:26 GMT

TableA TableB
1 1
1 1
2 1
2 2
2
2

Re: What will be the output if we do left join and Right join on the below table

Kurt_Bremser — Sun, 02 Jul 2023 06:34:03 GMT

See Maxim 4. Just try it.

Re: What will be the output if we do left join and Right join on the below table

animesh123 — Mon, 03 Jul 2023 09:37:59 GMT

I have already tried and know the output. I just required basic understanding of the output if anyone could help . Thanks

Re: What will be the output if we do left join and Right join on the below table

PaigeMiller — Mon, 03 Jul 2023 10:23:13 GMT

Please show us what you see and ask SPECIFIC questions about what you don't understand. Also show us the code you have used.

Re: What will be the output if we do left join and Right join on the below table

Kurt_Bremser — Mon, 03 Jul 2023 10:24:37 GMT

@animesh123 wrote:
I have already tried and know the output. I just required basic understanding of the output if anyone could help . Thanks

So you already have the answer. What is your real question then?

Re: What will be the output if we do left join and Right join on the below table

animesh123 — Mon, 03 Jul 2023 15:31:15 GMT

Required basic understanding of the output.

Re: What will be the output if we do left join and Right join on the below table

Tom — Mon, 03 Jul 2023 17:05:03 GMT

I cannot tell from your posts what you are asking about. You ask about joins but only showed a single dataset with only two variables. What are you joining? Do you want to join the table with itself? What are the join conditions? What is it you are trying to do? What output do you want to get?

If you tried it then show the code you tried. What part of if did you not understand?

Please be more detailed in what you are asking.

Re: What will be the output if we do left join and Right join on the below table

PGStats — Mon, 03 Jul 2023 18:57:22 GMT

A decent technical description of the SQL join operations (including the effect of missing (null) values) is given here.

Re: What will be the output if we do left join and Right join on the below table

Kurt_Bremser — Mon, 03 Jul 2023 19:13:46 GMT

From the documentation:

A left outer join, specified with the keywords LEFT JOIN and ON, has all the rows from the Cartesian product of the two tables for which the SQL expression is true, plus rows from the first (Lefttab) table that do not match any row in the second (Righttab) table.

A right outer join, specified with the keywords RIGHT JOIN and ON, has all the rows from the Cartesian product of the two tables for which the SQL expression is true, plus rows from the second (Righttab) table that do not match any row in the first (Lefttab) table.

Re: What will be the output if we do left join and Right join on the below table

PaigeMiller — Mon, 03 Jul 2023 21:27:30 GMT

@animesh123 wrote:
Required basic understanding of the output.

@animesh123: You are being asked to provide further information by a number of people. Repeating the above (and continuing to repeat the above) does not provide further information and does not enlighten us. Earlier, I said:

Please show us what you see and ask SPECIFIC questions about what you don't understand. Also show us the code you have used.

I am requesting you completely comply with the above request if we are going to be able to help you. Do not repeat "Required basic understanding of the output" as that is not what we are asking for.