comparing 2 mysql tables
| From: | Tom Churm | Date: | Fri, 24 Aug 2001 13:52:15 +0000 |
| Subject: | comparing 2 mysql tables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-64245@lists.php.net to get a copy of this message | ||
hi,
i've got 2 different MySQL tables. i need to check which entries in the
text-field 'User' in one table are NOT present in the 'User' field in
the other table. then i need to either save this array to a textfile or
otherwise prepare it for creating a new, third table.
any hints on how this kind of comparison operation can be accomplished?
many thanks,
tom