Hi,

I've a master and a detail table like

create table "SampleMaster" (
MasterID integer not null primary key,
OrderNo integer not null,
Comment varchar(20),
.
.
.
);

and

create table "SampleDetail" (
DetailID integer not null primary key,
MasterID integer not null,
OrderPos integer not null,
quantity integer not null,
.
.
.
constraint fk_MasterID foreign key (MasterID) references SampleMaster
(MasterID)
);

Is a query with a subquery faster then a joined query if I want all fields
from the SampleDetail and only OrderNo from SampleMaster?

TIA

Jörg Schiemann