| Performing Queries Using SQL |
| Querying Multiple
Tables |
|
Write a SELECT clause to select the columns
Name, Fee, Total,
BalanceDue, and AmountPaid, in that order. Define the
new column AmountPaid as the value of BalanceDue subtracted
from the value of Total. Indicate that values for
Name be read from Clinic.Admit. (Do not end the clause with a semicolon.) |
     |
|
|
|
Copyright © 2002 SAS Institute Inc., Cary, NC, USA. All rights reserved.