[Solved] What is the purpose of AND operator in SQL? How do I use AND in my query below?

by


Use this:

SELECT 
    c.LastName, 
    c.FirstName, 
    i.InvoiceId, 
    i.CustomerId, 
    i.InvoiceDate, 
    i.BillingCity,
    i.total  
FROM 
    invoices i 
INNER JOIN 
    customers c ON i.CustomerId = c.CustomerId 
WHERE 
    i.BillingCity = 'New York' AND i.total = 10

1

solved What is the purpose of AND operator in SQL? How do I use AND in my query below?