how to get current month data from two tables

[mfaisalwarraich]

Hi everyone,

I need to get the records for the current month from two tables. I know how to do it with one table. im using the following query for it:

SELECT * FROM mytable  WHERE YEAR(date_column) = YEAR(CURDATE()) AND MONTH(date_column) = MONTH(CURDATE())

This is giving me records for the one table only. but how i can get records from two tables?

please tell me.

Thanking you.

Faisal

[JKing]

Are these tables related?

[mfaisalwarraich]

no they are not related

[JKing]

You could use a UNION to join the records of two tables.

MySQl UNION

[mfaisalwarraich]

yeah UNION ALL worked for me :)