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

Join with different datatypes, HOW??

Status
Not open for further replies.
Dorine

Dorine

Programmer
Jul 18, 2002
14
CA
Dear all,

I would like to join two tables. The column to join on is char (8) on one table and varchar (8) on the other. Now I get an error. Does anybody know a solution??

Thanks!

Dorine
 
Sort by date Sort by votes
You should be able to join a char and a varchar

Post the code and the error message and we may be able to help identify the problem
 
Upvote 0 Downvote
I have made a simple mistake and fixed it myself. Thanks Hvass.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
398
Chris Miller
Chris Miller
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
541
EdLentz
EdLentz
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
428
Chris Miller
Chris Miller
jawadfrhad
  • Locked
  • Question
how make row to column
Replies
4
Views
182
jawadfrhad
jawadfrhad
Arthur Lewis
  • Locked
  • Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
133
Arthur Lewis
Arthur Lewis

Part and Inventory Search

Sponsor

Back
Top