Simple "Join" question

[jcale4]

Here is a very easy question about the display of data. I have a schedule table with data displayed like this (simplified):

NAME --- DATE --- TIME --- EVENT
--------------------------------
Jose --- 4/05 --- 4:00 --- PHONE
Jose --- 4/05 --- 5:00 --- LUNCH
Mary --- 4/05 --- 2:00 --- MEETING
Mary --- 4/05 --- 3:00 --- MEETING
Mary --- 4/05 --- 9:00 --- PHONE
Mary --- 4/05 --- 1:00 --- LUNCH

How can i "inner join" this data without actually joining on any column. I simply want to disply 2 Jose and Mary side by side (for ASP recordset purposes) with the time and event and in no particular order like this:

EVENT1 --- TIME1 --- EVENT2 --- TIME2
------------------------------------
PHONE ---- 4:00 ---- MEETING -- 2:00
LUNCH ---- 5:00 ---- MEETING -- 3:00
etc....

i was trying to do some sort of join with no condition like this:

select a.subcategory, a.starttime, b.subcategory, b.starttime from tblschedule a, tblschedule b where a.originalname = 'April Neuss' and b.originalname = 'Bruce Collins' and a.daterating = '04/04/2005' and b.daterating = '04/04/2005'

-- but, i get a cartesian where for every a.starttime i have a b.subcategory/b.starttime..

Is it possible just to display the data side by side with nulls where there are no equal records?

Thanks!

 

[r937]

why couldn't you do this with asp? "two-up" logic from a sorted result set is simple

the sql would be far too complex and involve inefficient temp tables, etc.

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[jcale4]

I'm not familiar with "two-up" logic, but i am currently looping two recordsets in the page, which works, but i'm trying to free up my web server from these types of processes. I'll try to improve on what I'm doing now.

Thanks for the info!