[thelist] SQL to copy row from one table to another...

[Rory.Plaire at wahchang.com]

| I need to copy
| that row from the temporary table to the regular 
| table...what's the SQL for
| that?

<mask face="rudy">

Hey,

Try:

INSERT INTO table 	
(	pk_id
,	field1
,	field2
,	field3
)


SELECT	pk_id
,		field1
,		field2
,		field3
FROM		temp

WHERE	temp.pk_id = confirmed_value

</mask>

<rory disposition="satisfied for actually, finally knowing somethin'"
alt="8)"/>