declare @order table(ID int,Name varchar(20))
declare @Detail table(ID int,Price float)

insert into @order(ID,Name) values(1,'aa'),(2,'bb'),(3,'cc')
insert into @Detail(ID,Price) values(1,10.5),(2,12.3),(4,5.9)

select * from @order
select * from @Detail