how to reconcile two tables using cursor.

Hi! I'm new here.
Here's my problem.

How can u reconcile two tables using cursor?
I would like to create a new table reflecting the matching records of the two tables I've compared.
how will i do this?
please help.Heya, ssshhh. Welcome to TSDN!

What database server software are you running?|||thnx for the welcome.
I'm using ms sql server 2000.

im doing a reconciliation report.
how can i insert the matching records into a new table?|||

Quote:

Originally Posted by ssshhh

thnx for the welcome.
I'm using ms sql server 2000.

im doing a reconciliation report.
how can i insert the matching records into a new table?

Now that we know your RDBM, we can direct you to the proper place to post.
That would be in the SQL Server/MSSQL Forum.

Also, please take some time to check out our Posting Guidelines. Thanks.|||Moving to the MS SQL forum...|||am i not in the mssql forum already?|||Use joins for your purpose and create the table based on that.

If u want to continue the process create a view instead.|||Heya, ssshhh.

Quote:

Originally Posted by ssshhh

am i not in the mssql forum already?

You are now ~_^