Or и and в sql запросах

SELECT dt.id, dt.namefile
FROM jointable jt
JOIN dt ON
Jt.idbase=dt.id
JOIN tagetable ON
Jt.idtege=tagetable.id
WHERE tage LIKE `w%` OR tage LIKE`e%`

SELECT dt.id, dt.namefile
FROM jointable jt
JOIN dt ON
Jt.idbase=dt.id
JOIN tagetable ON
Jt.idtege=tagetable.id
WHERE tage LIKE `w%` AND tage LIKE`e%`

WHERE tage LIKE `w%e%` OR tage LIKE `e%w%`

WHERE iddata = 1 AND idtage = 1

SELECT dt.id, dt.namefile
FROM jointable jt
JOIN dt ON
Jt.idbase=dt.id
JOIN tagetable ON
Jt.idtege=tagetable.id
WHERE tage LIKE 'w%' OR tage LIKE'e%'

WHERE iddata = idtage

SELECT dt.id, dt.namefile
FROM jointable jt
JOIN dt ON
Jt.idbase=dt.id
JOIN tagetable ON
Jt.idtege=tagetable.id
WHERE tage LIKE 'w%'

SELECT dt.id, dt.namefile
FROM jointable jt1
JOIN dt ON
jt1.idbase=dt.id
JOIN tagetable ON
jt1.idtege=tagetable.id
WHERE tage LIKE 'w%' 
INTERSECT 
SELECT dt.id, dt.namefile
FROM jointable jt2
JOIN dt ON
jt2.idbase=dt.id
JOIN tagetable ON
jt2.idtege=tagetable.id
WHERE tage LIKE 'e%'

DECLARE @s TABLE (t VARCHAR(100) PRIMARY KEY);
INSERT INTO @s
VALUES
 ('W'), ('e')
 
SELECT
 *
FROM Jointable jt
JOIN dt ON
Jt.idbase=dt.id
JOIN tagetable
Jt.idtage=tagetable.id
WHERE
 (SELECT * FROM @s WHERE tagetable.tage LIKE t+ '%') = (SELECT * FROM @s)