jfreeman2010
asked on
t-sql help on read 1 table 2 columns data and look for result
Hi I have the following example problem:
TEST_TB:
LOC_ID LOC_ID2
------ -------
11111 11111
11112 11112
11113 11114
11114 11114
11112 11115
RESULT
------
11111
11112
11113
11114
11115
the result is reading the TEST_TB table, column LOC_ID and LOC_ID2, distinct the LOC_ID and LOC_ID2 values.
Thanks
TEST_TB:
LOC_ID LOC_ID2
------ -------
11111 11111
11112 11112
11113 11114
11114 11114
11112 11115
RESULT
------
11111
11112
11113
11114
11115
the result is reading the TEST_TB table, column LOC_ID and LOC_ID2, distinct the LOC_ID and LOC_ID2 values.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS,
ASKER