SQL CE Query Keep Executing On Join

The following query runs fine
1)

Select cd.*

from TaxByPackage p join TaxOverrideReason tor

on tor.TaxId = p.TaxId

and p.PackageId in (10, 11)

join CalcData cd on cd.CalcTaxOverrideID = tor.TaxOverrideID



2)

but if I add following Join to above query then query does produce results and keep saying 'executing' for hours
"join TaxRate tr on tr.CalcDataID = cd.CalcDataID


Select cd.*

from TaxByPackage p join TaxOverrideReason tor

on tor.TaxId = p.TaxId

and p.PackageId in (10, 11)

join CalcData cd on cd.CalcTaxOverrideID = tor.TaxOverrideID

join TaxRate tr on tr.CalcDataID = cd.CalcDataID





3)

If I insert the data produce by first join 1) to a table and then join the new table data result to

Taxrate table then result come fine



insert into c1

select cd.*

from TaxByPackage p join TaxOverrideReason tor

on tor.TaxId = p.TaxId

and p.PackageId in (10, 11)

join CalcData cd on cd.CalcTaxOverrideID = tor.TaxOverrideID



select * from c1

join TaxRate tr on tr.CalcDataID = c1.CalcDataID





FYI : Version SQL CE is 3.0.5300