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.
