Left join date

[JeffModen]

@jtaniarto

Hi,
I have 2 tables . table A is calendar data it is contain of date of every days in a year ( start from january 1st until 31st December ) and table B is transaction contain of transaction history.
I need to join them based on the date so the result can be as below

date transid
01/11/2019 A0001
02/11/2019 A0002
03/11/2019 0
04/11/2019 A0003
05/11/2019 A0004
06/11/2019 0
07/11/2019 0
so on..
I try to make it by join the date between those table but it is not working. It shows only for existing data on table B it cannot show the all the calendar date . please help

thx

Joe

Hey there, @jtaniarto ... please don't post the same question twice on duplicate posts. It only serves to split up answers that other people have made.

For anyone interested, here's the other post.

Left join date record

Hi, I have 2 tables . table A is calendar data it is contain of date of every days in a year ( start from january 1st until 31st December ) and table B is transaction contain of transaction history. I need to join them based on the date so the result can be as below date transid 01/11/2019 A0001 02/11/2019 A0002 03/11/2019 0 04/11/2019 A0003 05/11/2019 A0004 06/11/2019 0 07/11/2019 0 so on.. I try to make it by join the date between those table but it is not working. It shows only fo…