I need to update a table without disturing the recordset however there are
or could be some overlaps with data is there a way I can compare id fro
the same 2 tables, one new one old?
andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
AM COMS [EMAIL PROTECTED] wrote on 01/23/2006 10:01:17 AM:
I need to update a table without disturing the recordset however there
are
or could be some overlaps with data is there a way I can compare id fro
the same 2 tables, one new one old?
andrew
Your question is quite vague. What
Andrew,
I need to update a table without disturing the recordset however there are
or could be some overlaps with data is there a way I can compare id fro
the same 2 tables, one new one old?
Here's one way...
SELECT
MIN(TableName) as TableName, id
FROM (
SELECT 'Table a' as TableName, a.id