This is what I have on my sql now. I want to to add my MoonPhaseTable to this how do I do it what would be my sql
PARAMETERS [Enter Number:] Text ( 255 );
SELECT T1.YourNumber AS [Operative Number], T1.YourDate AS [Operative Date], T2.YourNumber AS [Related Number], T2.YourDate AS [Related Date]
FROM YourTable AS T1, YourTable AS T2
WHERE (((T1.YourNumber)=[Enter Number:]) AND ((T2.YourDate)>=[T1].[YourDate]-2 And (T2.YourDate)<=[T1].[YourDate]+2 And (T2.YourDate)<>[T1].[YourDate]))
ORDER BY T1.YourDate, T2.YourDate;