compare two fields of two different tables

Question

0.00/5 (No votes)

See more:

how to compare two fields of one table to two fields of another table when no. of records are not same? and count the matching rows in both the tables

Posted 4-May-13 23:40pm

sandhyagor

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2013-05-05T00:25:00

Solution 1

This could help you:

SQL

select count(*) from 
TABLE_A A inner join TABLE_B B on (A.FieldA1=B.FieldB1 and A.FieldA2=B.FieldB2)

Posted 5-May-13 0:25am

Zoltán Zörgő

Comments

sandhyagor 5-May-13 9:43am

thanx...
i tried it but its nt working :(

sandhyagor 5-May-13 10:04am

got the solution by altring your query..
thank u so much :)

Zoltán Zörgő 5-May-13 10:09am

I am glad to read this. My answer was a schema, of course you needed to adjust to your actual needs.

sandhyagor 5-May-13 10:29am

yea.. thanx again :)

compare two fields of two different tables

1 solution

Solution 1

Add your solution here

Preview 0

compare two fields of two different tables

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us