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.
"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.
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:http://l
