Hi Ramesh,

Thank you for your interest ...

These tables are linked by two fields "MonthYear" and "MonthDay".

Output should be like ...

1. All respective rows from @tblProject.

2. Remaining All rows from both tables with milestone "0".

In short I want all rows from @tblProject w.r.t. @tblMonthYear other wise “0” milestone for that rows which are not matched.Its like a Cartesian product but not a Cartesian product.

Thanks a lot

Jayraj