AND
AND returns rows that must satisfy all of the given conditions.
Syntax
condition1 AND condition2
Remark
This operator is not available through the Studio interface, so you must manually type it into a query on a SQL or SQL Script panel.
Example
SELECT ProductID, ProductName, ProductDescription
FROM /shared/examples/ds_inventory/products products
WHERE ReorderLevel > 5 AND LeadTime = '1 Day'