One more thing I forgot to mention that this works:

INSERT INTO demo
SELECT *
FROM demographics
WHERE MPI =17;

This is why it is odd that with a LEFT JOIN statement it crashes because it follows the same structure, an INSERTstatment followed by a SELECT statment.


Thanks again

Joe