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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TEXT field in result of qry where tables frm different dbs are joined?

Status
Not open for further replies.
xp8103

xp8103

Programmer
May 22, 2001
62
US
Whats the skinny on the SQL Server limitation in joining two tables from separate databases where the one of the fields in the output is of datatype TEXT?
I've tried it in Access and Crystal.

 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Group results into one row 3
2
Replies
37
Views
3K
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
815
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
686
grnzbra
grnzbra
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
389
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top