Dear Jon:

If you have a large number or rows to look at, it would certainly be easier
to let some SQL code do the walking.

You seem to indicate you want to compare all rows from within your table
having the same value in one column, Environment.

There are, as you show, 3 different possible actions:  a value of
Environment is found only once, a value is found in two rows and both are
identical in other particulars, or a value is found in two rows and are not
identical.  Unless the value of Environment is found more than twice, you
could also find multiple matches.  There could conceivably be 3 values with
"A" for Environment in one table and 2 in the other.  This would result in
there being 6 compared combinations between the two tables, with each being
identical or not identical.

To keep it simple, consider there to be only one other column to compare for
identical values.  This can be very easily extended to compare additional
columns.  I'm assuming the Dt (date?) column is not of interest for
comparison.  There's not point in whether the dates are the same between the
two sets, right?

SELECT *
 FROM tbl_AIPProfileVariables T1,
   tblAIPProfileVariables T2

In this first step, we set up a comparison between every pair of rows in the
table.  If there were 100 rows, this "cross product" would have 10,000 rows,
every rows being compared with every other row.

We can reduce this set by eliminating those rows where the comparison is
between two different values of Environment, as follows:

SELECT *
 FROM tbl_AIPProfileVariables T1,
   tblAIPProfileVariables T2
 WHERE T1.Environment = T2.Environment

Also, assuming Environment/Dt is a unique key taken together, we can
eliminate comparisons of any row with itself:

SELECT *
 FROM tbl_AIPProfileVariables T1,
   tblAIPProfileVariables T2
 WHERE T1.Environment = T2.Environment
   AND T1.Dt <> T2.Dt

Now, this result set can be reduced to show either those that do match or
those that don't match with respect to the other columns.  I'm not sure what
your other columns are named, or how many you have.  The example you gave
wraps and is difficult.  I'll just call them C1, C2, and C3.  You should be
able to adapt this to your actual column names:

SELECT *
 FROM tbl_AIPProfileVariables T1,
   tblAIPProfileVariables T2
 WHERE T1.Environment = T2.Environment
   AND T1.Dt <> T2.Dt
   AND T1.C1 = T2.C1
   AND T1.C2 = T2.C2
   AND T1.C3 = T2.C3

This provides any pairs that do match.  To see those that don't, negate the
last 3 rows:

SELECT *
 FROM tbl_AIPProfileVariables T1,
   tblAIPProfileVariables T2
 WHERE T1.Environment = T2.Environment
   AND T1.Dt <> T2.Dt
   AND NOT (T1.C1 = T2.C1
   AND T1.C2 = T2.C2
   AND T1.C3 = T2.C3)

To find rows without a match:

SELECT Environment
 FROM tblAIPProfileVariables
 GROUP BY Environment
 HAVING COUNT(*) = 1

If you want the format of results I think you show in your example, we'll
need to add a column describing "Missing", "Different", and "Identical" and
then create a union, filling in the missing columns from this last set.
Let's cross that bridge later, OK?

Tom Ellison