Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Select from many table

Author  Topic  abc Starting Member 48 Posts Posted - 2001-08-10 : 22:07:12 I need to get result from query below: " Select tradeID, tradename from Business where tradeID in (Select BusinessID from stock_market.hang.KindOfBusiness where BusinessKindID like '37111.5825581') " This querry use two tables from two database. Table Business from Business Dabatase. And table KindOfBusiness from Market Database. In the second "Select" query I used syntax: DatabaseName.Owner.Object to refer to KindOfDatabase, but I the server respond that I make mistake. I don't know how to do it ? Please help me Thanks :-) Thank you so much :-)