Hi, See also http://stackoverflow.com/questions/406294/left-join-vs-left-outer-join-in-sql-server
Regards, Thomas On Tue, Dec 27, 2016 at 11:13 PM, Christian Master <spe...@gmail.com> wrote: > 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 h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
