Re: Subselect query for a multi table insert single query

Hi Tom,
I tried this on the command prompt but got the following error:

admin=> INSERT INTO business_address (street_name, town, county, postcode, county_id, business_name_id) values
('xcasc','ascasc', 'ascasc', 'acasc', 2, currval('business_name_business_name_seq')); 
ERROR:  business_name_business_name_seq.currval is not yet defined in this session

Any ideas as to what is going on.

Cheers

Norm