Sql server 2005 update from join

Active 9 years, 8 months ago. Viewed 3k times. I have two tables. Improve this question. Juan Mellado Phil H Phil H I wasn't sure whether it would cause a sweep of the entire table without the limit in there, but I suppose it's smart enough to know that the compound key is the key and only affect that one row. Add a comment. Active Oldest Votes. Improve this answer.

Active Oldest Votes. Sample AND t1Aliased. Improve this answer. Bill Gregg Bill Gregg 6, 1 1 gold badge 19 19 silver badges 36 36 bronze badges. Hmmm, thought I'd tried that. Maybe it was the alias on the From table Anyway, thanks! If you could "Accept" so that this question is marked as answered, I'd appreciate it. Sure, looks like there's a minute minimum before Acceptance is allowed. Sign up or log in Sign up using Google. The other editions of SQL Server are available as a custom update or as an optional update.

To read them, visit the following Microsoft Web site:. SQL Server Express Edition with Advanced Services includes more features and makes it easier than ever to start developing powerful data-driven applications for Web development or for local desktop development.

Need more help? Expand your skills. Get new features first. A subscription to make the most of your time. Try 1 month free. Was this information helpful? A table is joined to itself based upon a field or combination of fields that have duplicate data in different records. The data-type of the inter-related columns must be of the same type or needs to cast them in same type. When all of the data you require is contained within a single table, but data needed to extract is related to each other in the table itself.

Please refer the sample database for table structure. ProductID , pv1. ProductVendor pv2 ON pv1.