Simple Select Statement - I think :)

[Karridy]

This is feeling very hard for me, but is surely very easy for many of you.
I have 2 Tables. "Events" and "Meals". Both have a columns named "EventDate" and "EventTime". I need to be able to compile a list of both and sort by event date and time. For example, a Meal @ 5:30 would place itself between a 4:00 Event, and a 6:30 Event.

PLEASE HELP ME!!!
Pending deadline doom

Thanks,
kaskenasy@publishingconcepts.com

 

[fluteplr]

Assuming you also have a field in these tables telling the name of the event or meal.

Select eventname name , eventdate, eventtime from events
union all
select mealname, eventdate, eventtime from meals
order by eventdate, eventtime.

If the 'name' field is not the same length in both tables pad the shorter one to match the longer one. If you are missing the field in one of the tables you can select a constant. (select 'meal ', eventdate etc.

 

[jmsp1]

what about

Select * from tableA
union
Select * from tableB
order by EventDate, ....