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.
| Author |
Topic |
|
rajukotla
Starting Member
9 Posts |
 Posted - 2008-07-11 : 05:54:48
|
I have to assign the relation between the two tables.
In first table,the key of DECIMAL type and in the second table,
the key of VARCHAR type.
How to assogn the relation??????? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-11 : 06:45:42
|
Do a INNER JOIN as usual.
Of the query doesn't work, cast then DECIMAL column to VARCHAR in the JOIN binding.
E 12°55'05.25"
N 56°04'39.16" |
 |
|
|
|
|
|
decimal<->varchar