Re: Why does ISQL give me a syntax error?

Greg, > UPDATE porder > SET (po_recdt, po_shipdt) = (SELECT tpo_recdt, tpo_shipdt > FROM potmp > WHERE tpo_c_no = po_c_no AND tpo_num = po_num) > WHERE po_c_no IN (SELECT tpo_c_no FROM potmp) > AND po_num IN (SELECT tpo_num FROM potmp); In the select statement you are only selecting from one table, but you have specified a join. I think this might be the problem. The where clause of the set statement (last two lines) should be enough. As always, correct me if I'm wrong everyone, I know nothing! Cheers, ----------------------------------------------------------------- | _ /\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | -----------------------------------------------------------------