Re: Join on IP Addresses
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Apr 2006 00:36:37 +0200
On Mon, 10 Apr 2006 11:06:02 -0700, Matthew Tisdel wrote:
If this has been answered already, or is better answered somewhere else, then
please let me know.
I need help with a query. I have a table with many fields of information
about servers and network equipment. IP address is the Primary Key. I am
attempting join this table to another table that includes MAC address and IP
Address only - it also has IP address as the Primary Key. When I join the
tables on the IP Address field, I get no matches at all. The Mac Address
table looks like this:
10.1.1.1 00-04-23-a6-a0-de
10.1.1.2 00-c0-9f-7a-15-c4
The table is designed with both fields as text fields. It seems to have
trouble joining on the IP addresses, which is the only common piece of data
that I have.
Thanks,
Hi Matthew,
Please pay a visit to www.aspfaq.com/5006. On that site, you'll find
step-by-step instructions on how to assemble the information yoou need
to post in order to allow others to replicate yoour problem.
If the tablles involved are llong (either in number of columns or in
number of rows), then please cut out unnecessary extra's from your post.
Do check if the script still works on an empty DB after this pruning,
and check that it still shows the behaviour you're having trouble with.
--
Hugo Kornelis, SQL Server MVP
.
- Prev by Date: Re: Server: Msg 170, Level 15, State 1
- Next by Date: Re: deleting duplicates
- Previous by thread: Server: Msg 170, Level 15, State 1
- Next by thread: Re: deleting duplicates
- Index(es):
Relevant Pages
|
|
