|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; ?
|• Select rows containing identical values in two columns||Stephen P. Fracek Jr.||17 Nov|
|• Re: Select rows containing identical values in two columns||Philip Hallstrom||17 Nov|