Hello Sir/Madam, I am using the spark sql for the data operation.
I have two tables with the same fields. Table 1 name address phone Number sagar india 22222222 Table 2 name address phone Number jaya india 2222222 I want to join this tables like the following way Result Table name address phone Number jaya india 2222222 sagar india 22222222 How can i join this table. I tried using the join command it add the table to left side. Please help me to solve this query. Thanks,