Query with multiple conditions

Question

I'm trying to select from a SQL query that gives me all the active employees and the terminated employees that's been terminated 30 days ago?

My table is tblEmpl and my estatus= 'A' is the employee status for active and 'T' for terminated

and the tdate = termdate

select *
from tblEmpl
where estatus = 'A' and estatus = 'T' and tdate >= '2022-02-14';

This doesn't work.

Data:

Name	Estatus	TermDate	Work
Bill	A		CAR
Jill	I		CAR
Dill	T	2022-02-24	CAR
PHil	T	2022-02-14	CAR

You should always aim to provide a minimal reproducible example with sample data and desired results - this provides clarity, and ensures your question is complete and working. — Dale K
– Dale K, Commented Mar 16, 2022 at 3:04

Dale K · Accepted Answer · 2022-03-16 03:13:43Z

3

Your logic as described requires an OR of the estatuses, not an AND, but an AND with tdate and estatus 'T' e.g.

select *
from tblEmpl
where (estatus = 'A' or (estatus = 'T' and tdate >= '2022-02-14'));

edited Mar 16, 2022 at 3:13

answered Mar 16, 2022 at 2:51

Dale K

28.1k15 gold badges59 silver badges86 bronze badges

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

2 Comments

UnknownCoder45 Over a year ago

This doesn't get my actives just the terminated

UnknownCoder45 Over a year ago

This is real employee data thats why I didn't provide and If I select * from tblEmpl where estatus ='A' it gives me all the active employees it seem to me the only thing it's finding is the the tdate>='2022-02-14'

Collectives™ on Stack Overflow

Query with multiple conditions

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related