Search : in
By :

How to compare data between two tables

Last answer on Jul 17, 2009 4:37:57 am BST Stace, on Jul 14, 2009 10:18:01 am BST 
 Report this message to moderators

Hello,

I have two tables (table A and table B) and I need to compare the two tables to see if a specific userid exist in both tables. If the id exist in both tables then I want to paste the information from A into another table.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « How to compare data between two tables » in :
[MySQL]Loading a text file into ue table Show[MySQL]Loading a text file into ue table To load a text file as follows: $ tail /home/user1/test.txt 'name1',1,9 'name2',2,3 'name3',3,54 'name4',4,2 'name5',5,9 In a table defined as follows: CREATE TABLE...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Comparing the contents of two folders ShowComparing the contents of two folders Under XP, it is possible to integrate a function that allows you to compare the contents of two folders. This may be useful when dealing with folders containing a lot of files and that you...
Download CompareData Show
Download K Database Magic ShowK Database Magic is an application of SQL databases totally free. It allows you to manage, merge, compare data and more. The comparison is based on data fields specified by user. Advantages: it allows the execution of multiple SQL queries, editing...
Download DBConvert for Access & MS FoxPro Show
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Databases - Using forms ShowUsing forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Ask your question Reply

1

Excelguru, on Jul 17, 2009 4:37:20 am BST
  • +1

Use =countif(RangeSecondTable, "=" & useridFirstTable) if greater than 0 then it means the userid exists
so put a IF statement to above to copy your data Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.

   
Reply to Excelguru

2

 Excelguru, on Jul 17, 2009 4:37:57 am BST

Use =countif(RangeSecondTable,"=" & useridFirstTable) if greater than 0 then it means the userid exists
so put a IF statement to above to copy your data Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.

   
Reply to Excelguru
Ask your question Reply
They need your help