Newby - a question about working with two tables

Other SQL Server Topics
1

Hi

Can anyone help with this? The amount is in a different table from the other information

Write an SQL statement to retrieve the customer ID, first name, last name and order amount for customers from USA who made orders amounting 350 and over.

2

You can join tables to retrieve the amount. You can jump in rond 30 minutes.

3

Select a.customer_id, a.last_name,a.first_name, b.country, b.amount
from table A
left join table b on a.customer_id=b.customer_id
where b.country ="USA"
having amount >=350

4

having more than 1 record .. sum(amount)

filters if any

5

Thanks, this worked, I had to omit having and use and instead.