Hello Community,
I have encountered the following SQL problem trying to create a table from a SELECT statement.
I narrowed the problem down to the following example:
1. The SELECT statement alone works as expected.
SELECT m.Name, h.Status FROM EnsLib_HL7.Message m, Ens.MessageHeader h WHERE h.MessageBodyClassName='EnsLib.HL7.Message' AND h.MessageBodyID = m.ID
2. But if "CREATE TABLE ... AS" is added it fails