Oracle SQL Out put two table at a query -

create table products ( id int, name varchar(70),  price number(8,2), primary key (id, name) );   drop table instock; /* delete tables if exist */  create table instock (     id int,     quantity int ); 

i have 2 table in database. want have 2 table showing output table

id name price quantity 

select a.id,a.name,a.price,b.quantity products a,instock b a.id=b.id