Using MySQL Joins?

[m_tt]

Ok I have the following tables:

sum_200303
sum_200304

I need to select from a range of dates.. say from 2003-03-01 to 2003-04-20 which mean I have to select from 2 tables.

I need to get the SUM of FIELD like SUM(FIELD) from both tables for the date range..

The date range isnt the problem, the problem is the mysql query. I dont want to have to query each date so I wanted to use something like

SELECT SUM(FIELD) FROM sum_200303,sum_200304 WHERE INP_DATE >= '2003-03-01' AND INP_DATE <= '2003-04-20'

but that will not work with 2 tables, I keep getting some "in field list is ambiguous" crap 🙁

please someone help... thanks

[dnszero]

If both tables have the same structure, check out the mysql MERGE table command. It lets you basically put 2 or more tables together and treat it as 1 long table.

[sivasankari_kv]

You haven't specified whether the INP_DATE is in sum_200303 or in sum_200304
if INP_DATE is in both the tables then u will get this error

SELECT SUM(FIELD) FROM sum_200303 s1,sum_200304 s2 WHERE s1.INP_DATE >= '2003-03-01' AND s2.INP_DATE <= '2003-04-20'

this shud work