sql database problem

can anybody help with this problem

using a single insert into .... Select....command, create a hiring transaction for Mr f Curlew for the XJ6 4000 for October 10th 1997 at 10:00. do this without visually inspecting the tables to find out the relevant registration number and account number - get sql itself to look up the tables.

why does the below not work?

insert into hiring (regno, time_out,cust_acc) values ((select regno from car where model = 'XJ6' and esize = 4000), to_date ('10-OCT-97' 10:00:00,
'DD-MM-YY' H24:MI:SS'),
(select acc_no from customer where name = 'Mr F Curlew');

error message reads : missing expression @ values ((select

thanx in advance

mark Received on Sun Mar 19 2000 - 15:40:09 CST