I'm trying to do a join on two tables A and B.

A [id, name]
B [id, ...]

I want to join b.id = a.id, however, if there is no match, i want to specify a value for B to match on (ie the first record in the table).

is that possible?