I am trying to embed one SQL statement inside another as:
SET country = (SELECT ID FROM countries WHERE
countries.NAME = c_country) ;
WHERE client.client_id = sequence_table.client_id
but I receive an error message "Function name is missing)."
There is an MSDN example as follows:
SELECT company FROM customer a WHERE ;
EXISTS (SELECT * FROM orders b WHERE a.postalcode =
so SQL statments can be embedded in other SQL statements.
I've tried variations on the syntax without success. Can anyone help me
PS In case it helps, what I am trying to do is use the COUNTRIES table
as a lookup table. The user selects the country, and the associated
Integer value from the COUNTRIES table will be inserted into my CLIENT