Re: Table aliases on a DELETE statement

Jacob Salomon (jake@apparel.net) wrote: : In an application, I am preparing a DELETE statement very much like : this: : delete from gpprgtab t where t.modname = "X" and t.progname = "Y" : I get a 201 syntax error message: : delete from gpprgtab t where t.modname = "X" and t.progname = "Y" : # ^ : # 201: A syntax error has occurred. Jake, Try this: delete from gpprgtab where gpprgtab.modname = "X" and gpprgtab.progname = "X"; You can use the actual table name when referring to a column in both a delete statement and a update statement. --- Travis Rayhons trayhons@dordt.edu Dordt College Computer Services (712) 722-6299 (w) Programmer/Systems Administrator