|
|||||||
| SQL Course SQL Course > Ask questions about the lessons on SQL Course 1 and 2. If you have problems > with the interface, please post in the Feedback forum |
|
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
09-21-2002, 03:23 AM
|
|||
|
|||
|
how to update a field from the result of an innerjoin query
Hi,
I want to update the balance field from the client table from the result of a query (This query calculates the balance (accounts.amount_due - accounts.amount_paid) and selects all clients which are are disconnected (client.disconnected=false)) How do I do this? Thank you :) 
|
|
|
«
Previous Thread
|
Next Thread
»
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
Linear Mode
|
|
All times are GMT -5. The time now is 04:00 AM.
 |
 |
 |
 |