create table #parent (parentID int, pName char(2));
create table #child (childID int, parentID int foreign key references #parent, cName char(2), cDate dateTime);
-- DML data population
insert into #parent (parentID, pName)
values (1,'MD');
insert into #parent (parentID, pName)
values (2,'PM');
insert into #child (childID, parentID, cName, cDate)
values (5,1,'a','1/12/2004');
insert into #child (childID, parentID, cName, cDate)
values (6,2,'b','1/17/2004');
insert into #child (childID, parentID, cName, cDate)
values (7,1,'c','1/23/2004');
insert into #child (childID, parentID, cName, cDate)
values (8,1,'d','1/19/2004');
Requirements:
I want all rows from #parent table and one row for each parent ID from #child table.
Have fun.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
