How to join tables

From: JN <jirinej_at_volny.cz>
Date: 1 Jul 2003 02:23:07 -0700
Message-ID: <7e29a94a.0307010123.92fe48c@posting.google.com>

I have these two tables

Calendar (rows are pregenerated for every day)

DATE DAY

---

1.5.2003 Th
2.5.2003 Fr
3.5.2003 Sa

...

And Data

DATE TIME

---

2.5.2003 10:30
2.5.2003 14:00
4.5.2003 12:00
4.5.2003 17:00
4.5.2003 19:00

...

I am not able to join these two tables so the result would be this

DATE TIME

---

1.5.2003  NULL
2.5.2003 10:30
2.5.2003 14:00
3.5.2003  NULL
4.5.2003 12:00
4.5.2003 17:00
4.5.2003 19:00
  

Using outer join always selects only rows which exist in Data. One condition - I cannot use UNION ! Please help, thanks. Received on Tue Jul 01 2003 - 04:23:07 CDT