I don't really know SQL ... I simply hack and slash in these rare occasions when I need to cook up a query. I was hoping someone could help me phrase my query... Lets say I have two tables A and B. For each row in table A, I want to insert that row into table B if a condition is met. Thanks.

Quote:Original post by fpsgamer
Lets say I have two tables A and B. For each row in table A, I want to insert that row into table B if a condition is met.

INSERT INTO B SELECT * FROM A WHERE condition