I'm trying to make this sql query with sense:
nvl(t1.date, (SELECT t3.date from t3 WHERE t3.name=t1.name)) as date,
//other t1 and t2 fields
FROM t1 INNER JOIN t2 on t1.id=t2.id
Inner join is not a problem but I don't know how to get date field. Can anyone help?
I was thinking about mapping, but I really don't know how to use it with two conditions.