OUTER JOIN doesn not work. But LEFT OUTER JOIN does. So LEFT OUTER JOIN seems to be like FULL Join, or am i missing something? thx
Am Montag, 26. Dezember 2016 10:56:50 UTC+1 schrieb Steve McLeod: > > I guess this is what you want: > > SELECT ... FROM tableA a OUTER JOIN tableB b on a.date = b.date > > > > On Saturday, 24 December 2016 13:11:22 UTC+1, Christian Master wrote: >> >> Hi, >> i have >> tableA (date, moneyIn) >> >> tabelB (date, moneyOut) >> >> i need >> select a.date, a.moneyIn, b.moneyOut >> from >> tableA a >> full join >> tableB b >> a.date=b.date >> >> How to do it in H2, i think full join is not supported? >> thx >> chris >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
