SQL syntax Newbie student
Posted
by sammysmall
on Stack Overflow
See other posts from Stack Overflow
or by sammysmall
Published on 2010-04-21T19:24:35Z
Indexed on
2010/04/21
19:33 UTC
Read the original article
Hit count: 330
Describe the output of the following SQL query:
select custId, name
from customer
where region = "New York"
UNION
select cust.custId, cust.name
from customer cust
where cust.custId IN (select cust_order.custId
from customer_order cust_order, company_employee comp_emp
where cust_order.salesEmpId = comp_emp.empId
AND comp_emp.name = 'DANIEL');
My question is: at line from customer cust
is cust referring to a column in the customer table...
This is a homework question I have identified the components leading up to this line and I think that cust is a column in the customer table... I am not asking for an overall solution just a bit of encouragement if I am on the right track...
© Stack Overflow or respective owner