How to compare same field in two tables in sql server 2005 using C#
-
Hi, Can anyone help me with small sample for : How to compare same field in two tables in sql server 2005 using C# thanks
As I getting, you need to get value from two table based on same value. if so then Join Will be better option for your query. Joins allow you to view data from related table in a single result set. you can use any one of Three way of join. Inner Join, Outer Join, Left Join, Move Google for More Information:suss:
-
Hi, Can anyone help me with small sample for : How to compare same field in two tables in sql server 2005 using C# thanks
cancerion wrote:
compare same field in two tables
Your question confusing little bit. Based on my guess you may use Alias.(I think you mentioned Same field like same field name in two tables)
SELECT A.*, B.* FROM TableA AS A, TableB AS B WHERE A.Field1 > B.Field1
If not then let us know & mention clear details in your question.
thatraja |Chennai|India|
Brainbench certifications
Down-votes are like kid's kisses don't reject it :-)
Do what you want quickly because the Doomsday on 2012 :-)