Match column between two tables

Question

Match column between two tables

Shambhu Rai 1,411

Hi expert wants to match data between two table or not Create table table1(col varchar (20)) Create table table2(col varchar(20)) Insert into table1 values (20) Insert into table2 values (20) Insert into table1 values ('test') Insert into table2 values ('test1') Expected output Output1 ='row 2 data missmatch' Scenario 2 Create table table1(col varchar (20)) Create table table2(col varchar(20)) Insert into table1 values (20) Insert into table2 values (20) Insert into table1 values ('test') Insert into table2 values ('test') Expected output ='output matched'

Viorel 125.3K Reputation points

2023-10-14T05:54:23.23+00:00

To compare the rows, the tables should include primary keys, for example.

To evaluate the deleted data, you can use: select col from table1 except select col from table2.

To evaluate the new data: select col from table2 except select col from table1.

It is difficult to find the changed data without unique key columns.
Shambhu Rai 1,411 Reputation points

2023-10-14T08:56:22.5666667+00:00

Hi Expert,

Create table table1_new(col varchar (20),col1 varchar (20))

Create table table2_new(col varchar(20),col1 varchar (20))

Insert into table2_new values (10,60)

Insert into table2_new values (20) Insert into table2_new values ('test','test3')

Insert into table2_new values ('test1')

select col,col1 from table1_new except

select col,col1 from table2_new

wrong output.... it suppose to show both rows as it is not matched:

2 answers

Your answer

Viorel 125.3K Reputation points

2023-10-14T05:54:23.23+00:00

To compare the rows, the tables should include primary keys, for example.

To evaluate the deleted data, you can use: select col from table1 except select col from table2.

To evaluate the new data: select col from table2 except select col from table1.

It is difficult to find the changed data without unique key columns.
Shambhu Rai 1,411 Reputation points

2023-10-14T08:56:22.5666667+00:00

Hi Expert,

Create table table1_new(col varchar (20),col1 varchar (20))

Create table table2_new(col varchar(20),col1 varchar (20))

Insert into table2_new values (10,60)

Insert into table2_new values (20) Insert into table2_new values ('test','test3')

Insert into table2_new values ('test1')

select col,col1 from table1_new except

select col,col1 from table2_new

wrong output.... it suppose to show both rows as it is not matched:

Answer 1

Olaf Helper 47,581

Hi expert wants to match data between two table or not

"To be or not to be".

Your post is very unclear, the "SQL code" is hard to read and the logic for "expected output" is missing.

Please post the missing details and remove unrelated tags.

Answer 2

Bruce (SqlWork.com) 81,701 Volunteer Moderator

first:

Create table table1(col bar chart (20))

is not valid syntax

second, your insert mix number and string for the same column. also an error.

third, you appear to want to match on row number, but sql table rows do not have a row number, without an order by clause the order is undefined. you need to add insert order column.

if you don't care about the order then just use left and right joins

Shambhu Rai 1,411

Create table table2(col varchar(20))      It should match the columns in both the tables data should matched... Corrected the datatype... Apology

Share via

Match column between two tables

2 answers

Your answer