hai,
can we pass a select query as a value to insert query.for example
insert into table2(cno) values(select count(customerid) as cno from table1 where (departure-arrival)=1)
Thanks.