List:General Discussion« Previous MessageNext Message »
From:Philip Hallstrom Date:November 17 2007 5:00am
Subject:Re: Select rows containing identical values in two columns
View as plain text  
> 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;

?
Thread
Select rows containing identical values in two columnsStephen P. Fracek Jr.17 Nov
  • Re: Select rows containing identical values in two columnsPhilip Hallstrom17 Nov