Using Oracle SQL * plus multi-table joint investigation
[Users questions | Browse:109 | Favorites]
Users questions: Suppose I have two tables in the database "worker" and "customer" of these two tables have their names listed ("wname" and the "cname") and the city column ("ncity" and "ccity") . Now you want to find in the city "LA" All of the worker and the customer, requires the final result is two columns, the first column write the name, the second column is the worker that the person to or customer. What specifically should be how to write this sql?
Experts answer: home, the machine did not install Oracle, So I can not try. You try it. Note that the results you may have duplicate names. Worker and the customer set the table column names are name, city (so good). SELECTname, 'worker'ASoFROMworkerWHER Ecity= LA UNIONALLSELECTname customer ASoFROMcustomerWHEREcity= LA
Experts answer: home, the machine did not install Oracle, So I can not try. You try it. Note that the results you may have duplicate names. Worker and the customer set the table column names are name, city (so good). SELECTname, 'worker'ASoFROMworkerWHER Ecity= LA UNIONALLSELECTname customer ASoFROMcustomerWHEREcity= LA
- Please help me find this master can be used to achieve innerjoin
- Jiji Ji! ! ! Find data structure answers to all the points I gave up!
- Assistance, real estate appraiser exam! Urgent! ! ! ! ! ! ! ! ! ! ! ! !
- How to separate the data Excell
- the relationship between mysql and php?
- What are the dimensions of the report?
- Where to start to learn software testing
- What does it mean 100B5F27BB4040D
- How to count? ? ?
- Help write a SQL trigger ah? ? Really do not know
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.