David Westbury <pe8...@yahoo.com> wrote: > For example, why won't an embedded select statement similar to the following > work? > > INSERT INTO ORDERS (OrderNo, P_Id) > values ( > 12345, > select P_Id from persons where LastName = 'Hansen')
Because it's not valid SQL. Try this one: INSERT INTO ORDERS (OrderNo, P_Id) values ( 12345, (select P_Id from persons where LastName = 'Hansen')); The nested select should be enclosed in parentheses. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
