Hi I am doing a query using MSSQL Mgt Studio in design view ( because I no nothing). On MS SQL server 2005
SELECT patient_name.*, patient_address.*, doctor.*
FROM patient_name CROSS JOIN
patient_address CROSS JOIN
doctor
I need to limit the query to the past 12 months (so the server doesn't gag) and produce an output I can eventually import into Excel
FROM patient_name CROSS JOIN
patient_address CROSS JOIN
doctor
where <myDatecolumn> > dateadd("m",-12,getdate())