Re: SELECT query with OUTER JOIN - problem

2003-06-03 Thread Jim Winstead
On Mon, Jun 02, 2003 at 12:48:38PM +0200, Dejan Milenkovic wrote: I have two tables, one is containing data about courses and the second one is containing data about course start date. Is it possible to list all courses with one query which should also return earliest scheduled start dates

SELECT query with OUTER JOIN - problem

2003-06-02 Thread Dejan Milenkovic
Hi, I have two tables, one is containing data about courses and the second one is containing data about course start date. Is it possible to list all courses with one query which should also return earliest scheduled start dates for courses (which are in the second table). I tried something like