Create Microstrategy Table Joins in Report

I give up!  I'm greating metrics in Microstrategy and then creating reports to verify them.
I'm viewing the Microstrategy code in SQL to confirm that it's what I want, but I keep getting "cross joins"  I've tried architech, metric join types, everything!  I have 300 metrics to verify!  Please help!  Both the microstrategy SQL code and the SQL code that I want are attached

Microstrategy
select	a12.MTD_DATE_ID  MTD_DATE_ID,
	count(a11.BOOKING_FACT_ID)  WJXBFS1
from	BOOKING_FACT	a11
	cross join	LU_MTD_DATE	a12
where	a12.MTD_DATE_ID in (20091231)
group by	a12.MTD_DATE_ID


SQL

select MTD_DATE_ID, count(booking_fact_id)   ---268
from booking_fact a
join dbo.LU_MTD_DATE b
on a.booking_date_id = b.date_id
where 
cancelled_flag =1
and mtd_date_id = 20091231
group by b.MTD_DATE_ID

Select allOpen in new window