Database

View All Threads First Prev Next

SQL Query - append results AndreFratelli5-Dec-12 6:43 AndreFratelli 5-Dec-12 6:43  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 Re: SQL Query - append results Chris Meech5-Dec-12 6:55 Chris Meech 5-Dec-12 6:55  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] Re: SQL Query - append results AndreFratelli5-Dec-12 7:08 AndreFratelli 5-Dec-12 7:08  It does indeed ! Thank you Fratelli

Last Visit: 31-Dec-99 18:00     Last Update: 3-May-24 11:31 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.