Blank Fields

[#1]

Date              Product            Ammount

1/1/2012            A                  5000

1/1/2012            B                  4000

1/1/2012            C                  500

2/1/2012

I have this type of data what i want is that all the rows of date 1/1/2012   should  repeat in 2/1/2012  like given below

Date              Product            Ammount

1/1/2012            A                  5000

1/1/2012            B                  4000

1/1/2012            C                  500

2/1/2012            A                  5000

2/1/2012            B                  4000

2/1/2012            C                  500

[alexandros17]

try with a left join with the same table so you can double values as you want