Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trouble using Calculate Fields in Update Query
Hey Toga, The fact that you are trying to write a field value to multiple tables raises a red flag. In a relational database you want to avoid duplicate entries. You may want to try to rethink about how your multiple tables store the same data and how they can be streamlined. If you need...- blouie
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Creating views accross multiple databases
Greetings, I'm fairly new to Microsoft SQL Server and specially TransactSQL. I've successfully created "Views" within a database using Enterprise Manager. I'm trying to create a view that will allow me to use two tables from two different databases in the SQL server. Is it...- blouie
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
