"Mike Hoff" <mike@home.com> wrote in message
news:10ogkr9pf826g69@corp.supernews.com...
> Hello,
>
> I need to get a single recordset combining 2 similar tables.
>
> Table 1: tblAppointment
> fields: AppStart (datetime), AppStop (datetime), AppName (varchar)
>
> Table 2: tblSchedule
> fields SchedStart (datetime), SchedStop (datetime), SchedName (varchar)
>
> I would like to get a single recordset:
>
> SELECT [SchedStart or AppStart as Start], [SchedStop or AppStop as Stop],
> [SchedName or AppName as Name]
> WHERE [SchedStart or AppStart='1/1/2005 12:00 pm']
>
> Is this possible or do I need to combine them inside my app?
>
> Thanks in advance.
>
>

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:eMQmSBWwEHA.384@tk2msftngp13.phx.gbl...
> You can use UNION ALL to concatenate results:
>
> SELECT
> SchedStart AS Start,
> SchedStop AS Stop,
> SchedName AS Name
> FROM tblAppointment
> WHERE SchedStart ='20050101 12:00:00'
> UNION ALL
> SELECT
> AppStart,
> AppStop,
> AppName
> FROM tblAppointment
> WHERE AppStart='20050101 12:00:00'
> GO
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Mike Hoff" <mike@home.com> wrote in message
> news:10ogkr9pf826g69@corp.supernews.com...
> > Hello,
> >
> > I need to get a single recordset combining 2 similar tables.
> >
> > Table 1: tblAppointment
> > fields: AppStart (datetime), AppStop (datetime), AppName (varchar)
> >
> > Table 2: tblSchedule
> > fields SchedStart (datetime), SchedStop (datetime), SchedName (varchar)
> >
> > I would like to get a single recordset:
> >
> > SELECT [SchedStart or AppStart as Start], [SchedStop or AppStop as
Stop],
> > [SchedName or AppName as Name]
> > WHERE [SchedStart or AppStart='1/1/2005 12:00 pm']
> >
> > Is this possible or do I need to combine them inside my app?
> >
> > Thanks in advance.
> >
> >
>
>

"Mike Hoff" <mike@home.com> wrote in message
news:10ogkr9pf826g69@corp.supernews.com...
> Hello,
>
> I need to get a single recordset combining 2 similar tables.
>
> Table 1: tblAppointment
> fields: AppStart (datetime), AppStop (datetime), AppName (varchar)
>
> Table 2: tblSchedule
> fields SchedStart (datetime), SchedStop (datetime), SchedName (varchar)
>
> I would like to get a single recordset:
>
> SELECT [SchedStart or AppStart as Start], [SchedStop or AppStop as Stop],
> [SchedName or AppName as Name]
> WHERE [SchedStart or AppStart='1/1/2005 12:00 pm']
>
> Is this possible or do I need to combine them inside my app?
>
> Thanks in advance.
>
>