Hi,
I have a MySQL database with two tables in it, both tables have the same three fields amongst others. I need to select all the records from one table which have some of the same value(s) in these three fields as those in the other table. I also need to order the records by the number of matches, i.e. records where all three fields match first and then the records where two fields match and so on. These fields are all strings.
Any ideas will be much appreciated.
I have a MySQL database with two tables in it, both tables have the same three fields amongst others. I need to select all the records from one table which have some of the same value(s) in these three fields as those in the other table. I also need to order the records by the number of matches, i.e. records where all three fields match first and then the records where two fields match and so on. These fields are all strings.
Any ideas will be much appreciated.