wozniak@utkux1.utk.edu (Bryon Lape) (07/04/90)
Does anyone know the SQL equivalent of R:BASE's APPEND command? I
know that the INSERT INTO command is supposed to do the same thing but I
cannot get it to word within the limits of line size. I need to copy
information from one table into another and the small of the two has 20
columns. Must I list all of the needed columns in the SQL command?
Here is what I did in R:BASE:
APPEND GenInfo TO StateMacTable WHERE Id# EXISTS
This will place all of the rows from GenInfo where a student id number
exists into the table StateMacTable. Since the StateMacTable is really built
out of the GenInfo table, there are no columns in the target that are not in
the source (except, of course, for computed columns). The SQL command seems
to need a list of all effected columns and will not do what the APPEND
command will do. Can anyone help?
-bryon lape-
PS-In case you are wondering why I would bother with the SQL, I am trying to
revise macros in R:BASE to fit the SQL standard, but I am starting to really
hate this committee joke of a language.