Consecutive result Set

Hello,
I am having two tables ...
SendMails (SendMailID,sender,subject)
Data is
1, 'Sender1','Subject1'
2, 'Sender2','Subject2'
3, 'Sender3','Subject3'
RecMails(RecMailId,Recieved,Subject)
Data is
4, 'Rec1','Subject4'
5, 'Rec2','Subject5'
6, 'Rec3','Subject6'
I want in the Report as
1, 'Sender1','Subject1'
2, 'Sender2','Subject2'
3, 'Sender3','Subject3'
4, 'Rec1','Subject4'
5, 'Rec2','Subject5'
6, 'Rec3','Subject6'
I am unable to get this from a single Query...
so I decided to have two tables in the body with one dataset each ...but it
leaves a big blank space in between .. Is there some way possible for this
requirement..
I also tried putting two tables in one group each within a third table but
the blank space remains...
any Idea will be highly appreciated..
Cheers,
siajAre you using a database that does not support a UNION in the query?
Otherwise, UNION them and have them in the same dataset.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"siaj" <siaj@.discussions.microsoft.com> wrote in message
news:E449AE49-ECE2-4B23-979D-D877C5BE3BC4@.microsoft.com...
> Hello,
> I am having two tables ...
> SendMails (SendMailID,sender,subject)
> Data is
> 1, 'Sender1','Subject1'
> 2, 'Sender2','Subject2'
> 3, 'Sender3','Subject3'
>
> RecMails(RecMailId,Recieved,Subject)
> Data is
> 4, 'Rec1','Subject4'
> 5, 'Rec2','Subject5'
> 6, 'Rec3','Subject6'
> I want in the Report as
> 1, 'Sender1','Subject1'
> 2, 'Sender2','Subject2'
> 3, 'Sender3','Subject3'
> 4, 'Rec1','Subject4'
> 5, 'Rec2','Subject5'
> 6, 'Rec3','Subject6'
>
> I am unable to get this from a single Query...
> so I decided to have two tables in the body with one dataset each ...but
> it
> leaves a big blank space in between .. Is there some way possible for this
> requirement..
> I also tried putting two tables in one group each within a third table but
> the blank space remains...
> any Idea will be highly appreciated..
> Cheers,
> siaj|||Thanks Douglas...
I am using SQL Server 2000...and I can very well use Union Operator.. It
had never clicked me..
Cheers,
siaj
"Douglas McDowell" wrote:
> Are you using a database that does not support a UNION in the query?
> Otherwise, UNION them and have them in the same dataset.
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "siaj" <siaj@.discussions.microsoft.com> wrote in message
> news:E449AE49-ECE2-4B23-979D-D877C5BE3BC4@.microsoft.com...
> > Hello,
> >
> > I am having two tables ...
> >
> > SendMails (SendMailID,sender,subject)
> > Data is
> > 1, 'Sender1','Subject1'
> > 2, 'Sender2','Subject2'
> > 3, 'Sender3','Subject3'
> >
> >
> > RecMails(RecMailId,Recieved,Subject)
> > Data is
> > 4, 'Rec1','Subject4'
> > 5, 'Rec2','Subject5'
> > 6, 'Rec3','Subject6'
> >
> > I want in the Report as
> >
> > 1, 'Sender1','Subject1'
> > 2, 'Sender2','Subject2'
> > 3, 'Sender3','Subject3'
> > 4, 'Rec1','Subject4'
> > 5, 'Rec2','Subject5'
> > 6, 'Rec3','Subject6'
> >
> >
> > I am unable to get this from a single Query...
> >
> > so I decided to have two tables in the body with one dataset each ...but
> > it
> > leaves a big blank space in between .. Is there some way possible for this
> > requirement..
> > I also tried putting two tables in one group each within a third table but
> > the blank space remains...
> > any Idea will be highly appreciated..
> >
> > Cheers,
> > siaj
>
>