Combining 2 sql statement

Question

I wanted to ask can any one help me to join this two statement into one

SELECT * FROM worker_leave WHERE YEAR(yearAppplied) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR))

And

SELECT * FROM worker_leave WHERE YEAR(yearAppplied) = YEAR(CURDATE())

I want to achieve counting the total leave a person have within current year and previous year total must not be more than 24 (Can be control at php side)

combine them how? the two where clauses are incompatible. a single value in a single field cannot be two different values at the same time. — Marc B
– Marc B, Commented Aug 9, 2016 at 15:13

RiggsFolly · Accepted Answer · 2016-08-09 15:19:31Z

4

SELECT * FROM worker_leave  
WHERE YEAR(yearAppplied) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)) 
   OR YEAR(yearAppplied) = YEAR(CURDATE())

This will give you combined results for both queries.

edited Aug 9, 2016 at 15:19

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

answered Aug 9, 2016 at 15:18

A. Onder

1247 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RiggsFolly · Accepted Answer · 2016-08-09 15:17:48Z

1

You can do

SELECT * FROM worker_leave WHERE YEAR(yearAppplied) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)) 
UNION 
SELECT * FROM worker_leave WHERE YEAR(yearAppplied) = YEAR(CURDATE())

Make sure the columns returned by both queries are indentical [in structure]

edited Aug 9, 2016 at 15:17

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

answered Aug 9, 2016 at 15:17

Peter

6,6994 gold badges33 silver badges36 bronze badges

Collectives™ on Stack Overflow

Combining 2 sql statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related