以下是我的2张表:
create table product(
id number primary key,
name varchar2(32) not null,
description varchar2(64),
price number(8,2) not null
);
create table item(
id number primary key,
amount number,
product_id number references product(id),
proname varchar(32)
);
我想把product的name和id字段查出来然后将值插入到item的product_id和proname字段中去
请问怎么写sql语句?在线等......
create table product(
id number primary key,
name varchar2(32) not null,
description varchar2(64),
price number(8,2) not null
);
create table item(
id number primary key,
amount number,
product_id number references product(id),
proname varchar(32)
);
我想把product的name和id字段查出来然后将值插入到item的product_id和proname字段中去
请问怎么写sql语句?在线等......
select product,name from product
要的是这个?
insert into item(product_id,proname) select id , name from product
基础不好,多谢
select sql_item.nextval, name from product;