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 |
|
rsegecin
Yak Posting Veteran
82 Posts |
 Posted - 2007-09-14 : 16:25:38
|
| When I "inner join tables" the columns, which are the point of reference to cross the data like "on u.user_id = t.user_id", doesn't need to be necessary primary keys. Thank you very much.Ideas are bullet proof.Vendetta. |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-14 : 16:32:58
|
No they don't.
Future guru in the making. |
 |
|
|
rsegecin
Yak Posting Veteran
82 Posts |
Posted - 2007-09-14 : 16:35:10
|
| but do they need to be type int?Ideas are bullet proof.Vendetta. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-14 : 16:41:34
|
quote:
Originally posted by rsegecin
but do they need to be type int?Ideas are bullet proof.Vendetta.
No, they just need to match datatypes ( or you can cast them ).
Future guru in the making. |
|
|
|
rsegecin
Yak Posting Veteran
82 Posts |
Posted - 2007-09-14 : 17:00:02
|
| Thank you very much Zoroaster and thank you indeed for say that I can also cast.Ideas are bullet proof.Vendetta. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-14 : 18:55:03
|
quote:
Originally posted by rsegecin
Thank you very much Zoroaster and thank you indeed for say that I can also cast.Ideas are bullet proof.Vendetta.
Any time.
Future guru in the making. |
|
|
|
|
|
|
Just to be definitely chore.