Same value in table for different rows
This is probably straight forward, but say I had a table:
If I wanted to execute a query asking if the table has the same game on both xbox360 and ps3, how would I go about doing that? So the condition would be TRUE for the table above because of rows 1 and 2 (xbox360 and ps3=cod4).
person_id surname console game
1 jones xbox360 cod4
2 bloggs ps3 cod4
3 smith wii bowling
4 another xbox360 cod4
Any advice appreciated.