Question
Accounts acctNo owner userid password balance 365556 Tony Jones tjones 456 819.37 499872 Frank Smith fsmith 123 590.81 761112 George Powers gpowers geo 239.41 765552
| Accounts | ||||
|---|---|---|---|---|
| acctNo | owner | userid | password | balance |
| 365556 | Tony Jones | tjones | 456 | 819.37 |
| 499872 | Frank Smith | fsmith | 123 | 590.81 |
| 761112 | George Powers | gpowers | geo | 239.41 |
| 765552 | Betty Davis | bdavis | atl | 356.21 |
| 872221 | Suzanne Austin | suze | suze | 622.22 |
| 899900 | Mary Wilson | mwilson | mary | 772.12 |
| Customers | ||||
|---|---|---|---|---|
| cid | cName | cAddr | cPhone | cEmail |
| tjones | Tony Jones | Miami, Fl | 514-999-2131 | tjones@yahoo.com |
| fsmith | Frank Smith | Dallas, Tx | 616-423-1717 | fsmith@haotmail.com |
| gpowers | George Powers | Chicago, Il | 612-901-2312 | gpowers@bellsouth.net |
| bdavis | Betty Davis | Nashville, Tn | 909-367-9485 | bdavis@yahoo.com |
| suze | Suzzane Austin | San Diego, Ca | 201-565-1902 | suze@yahoo.com |
| mwilson | Mary Wilson | Atlanta, Ga | 405-787-2911 | mwilson@hotmail.com |
Write an Update statement that will change the cName for suze in the Customers table to match the owner in the Accounts table(Use a SubQuery)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Data Mining Concepts And Techniques
Authors: Jiawei Han, Micheline Kamber, Jian Pei
3rd Edition
0123814790, 9780123814791
