Hello.
The INSERT ... VALUES and INSERT ... SET forms of the statement insert rows
based on explicitly specified values. So you can't use select in the value
clause.
Instead you should use insert ... select. By the way: don't forget to
escape single quotes in text which you insert.
See:
GH wrote:
I am trying to insert data in the ProgressNotes Table using the
following query but it does not work. Can someone please assist? Thank
You.
[snip]
'Understandably, the consumers were upset. The Dean (SR) was kind
enough to try and help explain to our members that there was a
In my database I have the following tables:
+-+
| Tables_in_AHRC |
+-+
| Attendance |
| Participants|
| ProgressNotes |
| Sessions|
| Staff |
| StaffAttendance |
+-+
I am trying to insert data in the ProgressNotes Table