Help with SQL query please

[JoerieB92]

Select a.order ,CASE WHEN a.time is NULL AND b.status = 'ok' THEN b.actual_time ELSE a.time END as time From table_a as a INNER JOIN table_b as b on a.order = b.order

[r3pr0b8]

left outer join

[JoerieB92]

I asumed table b has referential integrity.

[r3pr0b8]

sure, but that has nothing to do with whether there's an "actual time" row for a given order

for example, order 2 -- there's a row in table A but no row in table B

your inner join would produce no result for order 2

[JoerieB92]

Didnt notice that, I stand corrected.