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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linking tables with no foreign keys

Status
Not open for further replies.
eja2000

eja2000

Programmer
Nov 30, 2003
209
NG
What join do i use for 2 tables that are not linked by primary/foreign key but they have a similar field?
thx
 
Sort by date Sort by votes
Use any join but define an alternate index -- either on the table(s) itself or within the query logic on the fly.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Conditional Foreign Key Constraint
Replies
1
Views
441
Chris Miller
Chris Miller
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
1K
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
839
gmmastros
gmmastros
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
535
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top