Hi

i want to check the column which have mulitple values and retrieve the row

i have two tables one is games and another one is user

In Games table contain the 3 fields id,games,game_date

games(carrace,carrom,chess)

In user table have username,interstedgame,and etc...

so i want to retrieve the row from games table which is match the user interstedgame

i use code like this

select * from games g,user u where u.user in(g.games)


It didnt retrieve any row, if the games field contain one value means it display the one row if the games field have mulitple value means it didnt display any row

how could i code this please give any suggestion how to code


Thanks
sona