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 <[email protected]> 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 [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. > -- 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.
