SQL Query - append results
-
Hi everyone, I'm having trouble with this query in SQL (homework!). I have two tables: customer and staff. == Customer (the relevant fields) == customer_id first_name last_name == Staff == staff_id first_name last_name The question is: "select the first and last names of all customers and staff". Can anybody help on how to do that? I don't know how to "append" the results of the two queries, and googling I can only find about INSERT ... SELECT, which is not what I'm looking for =\ Best regards to all.
Fratelli
-
Hi everyone, I'm having trouble with this query in SQL (homework!). I have two tables: customer and staff. == Customer (the relevant fields) == customer_id first_name last_name == Staff == staff_id first_name last_name The question is: "select the first and last names of all customers and staff". Can anybody help on how to do that? I don't know how to "append" the results of the two queries, and googling I can only find about INSERT ... SELECT, which is not what I'm looking for =\ Best regards to all.
Fratelli
Perhaps the keyword "UNION" may help you. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
Perhaps the keyword "UNION" may help you. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
It does indeed ! :D Thank you ;)
Fratelli