sql server mseq: Join on IP Addresses -- sql server mseq

Join on IP Addresses

Matthew Tisdel
4/10/2006 11:06:02 AM

sql server mseq:

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,
--
Matthew Tisdel

Re: Join on IP Addresses

Hugo Kornelis
4/11/2006 12:36:37 AM

[quoted text, click to view]

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.

--