|
|||||||
| 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
12-29-2002, 10:47 AM
|
|||
|
|||
updating count fields
I have to build a database of firms that can have more than one address. It is formed by two Tables:
Table1 Firms Fields FirmID Firm name Number_of_sites Table2 Addresses SiteID FirmID SiteAddress Do you know if I can update the Number_of_sites field by using an UPDATE query with a count on the fields of the second table joined to the ones of the first? 
|
|
|
«
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 05:52 AM.
 |
 |
 |
 |