Nope, I have already tried that one... But this one returns 0 rows when eg. stoptype = 2.. (it works ok when stoptype = 1 or null...) But I should get one row when stoptype = 2 as well, but then with null values from fields in the log_stop table... I am not sure if this is possible, without writing a procedure or similar... BTJ Scott Marlowe wrote: > Then maybe: > > AND (log_stop.stoptype=1 OR log_stop.stoptype IS NULL) > > ?? > > On Mon, 2005-04-18 at 11:55, BjÃrn T Johansen wrote: > >>Nope... It returns 0 rows when there are no rows in log_stop with stoptype = 1... >> >>BTJ >> >>Scott Marlowe wrote: >> >>>On Mon, 2005-04-18 at 11:24, BjÃrn T Johansen wrote: >>> >>> >>>>I need a select like this..: >>>> >>>>select ordre.id, ordre.desc, log_stop.stoptype from ordre left outer join log_stop on >>>>ordre.id = log_stop.ordreid where ordre.id = 22 >>>> >>>>The problem is that I need to include "where log_stop.stoptype = 1". So if log_stop >>>>includes 3 rows with stoptype = 1 and ordreid = 22, my select should return 3 rows. >>>>Also, if log_stop includes 3 rows with stoptype = 1 and 2 rows with stoptype = 2, my >>>>select should still return 3 rows. And if there are 0 rows with stoptype = 1, my >>>>select should return 1 row. >>> >>> >>>Would this work? >>> >>>select ordre.id, ordre.desc, log_stop.stoptype from ordre left outer join log_stop on >>>ordre.id = log_stop.ordreid where ordre.id = 22 AND COALESCE(log_stop.stoptype,1)=1 >>> >>> ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
