SQL that returns every record twice
- From: Aino <aij@xxxxxxxxx>
- Date: Sat, 06 Oct 2007 02:20:24 -0700
I have a table that basically holds a start time and an end time for
an event. Now I want to generate a report that returns all events
sorted by time, whether something starts or ends.
Table StartTime EndTime Event
7.00 7.30 A
7.15 8.15 B
8.00 9.30 C
Report Time Event
7.00 A
7.15 B
7.30 A
8.00 C
8.15 B
9.30 C
Can anyone help with the SQL?
.
- Follow-Ups:
- Re: SQL that returns every record twice
- From: Marshall Barton
- Re: SQL that returns every record twice
- From: Allen Browne
- Re: SQL that returns every record twice
- Prev by Date: Re: select query not null
- Next by Date: Re: how to create item numbers column in a Query Options
- Previous by thread: Re: Top 3 Query Help
- Next by thread: Re: SQL that returns every record twice
- Index(es):