Table Join Help Needed...

From: <heizer1_at_llnl.gov>
Date: 15 Feb 2006 20:49:13 -0800
Message-ID: <1140065353.134693.19170@g43g2000cwa.googlegroups.com>

Hello,
I need help joining two tables with similar data but not exact.

Table 1: ADMSUB
Two Columns: SUBNET, DIRECTORATE_CODE

Example Entries...

128_112_33_ , EED
128_112_12_ , EED
128_116_14_ , DTD

Table 2: DEVICES
Three Columns: DEVICE_ID, OS, OS_VER

Example Entries...

128_112_33_12 , LINUX , 2.4
128_112_12_12 , WINDOWS , XP
128_116_14_1 , MAC , OSX

I would like to join these two tables so that the output looks like this...

128_112_33_12 , LINUX , 2.4 , 128_112_33_ , EED
128_112_12_12 , WINDOWS , XP , 128_112_12_ , EED
128_116_14_1 , MAC , OSX , 128_116_14_ , DTD

Everytime I try a query with a outer join or something I end up with nulls, can someone please tell me what I'm doing wrong.

Thanks,
- Charles Received on Wed Feb 15 2006 - 22:49:13 CST