Re: Select rows containing identical values in two columns

[Philip Hallstrom]

> I have a table that has a column with the id of the person that created the 
> row.  In another column in the same row there is a column with the id of the 
> person that modified that row.
>
> Is there a way to write a SELECT statement that will return all the rows 
> where the value in the creation column equals the value in the modification 
> column?  I don't want to specify a specific id in either of the columns.

SELECT * FROM your_table WHERE created_by_id = updated_by_id;

?