Re: get rows that have a filed in common with another row

2004-11-29 Thread Michael Stassen
andrej h wrote: Hello, I'm new to mysql (and databases, fo that matter) and have problems finding a solution. The situation is as follows: I have one table with filtered information about users, the columns are, say, id, field and value. As you can see, any id can have more rows assiciated with him

get rows that have a filed in common with another row

2004-11-29 Thread andrej h
Hello, I'm new to mysql (and databases, fo that matter) and have problems finding a solution. The situation is as follows: I have one table with filtered information about users, the columns are, say, id, field and value. As you can see, any id can have more rows assiciated with him, each containin