SQL Query question
From: Jaime J. Maiz <jmaiz_at_lucent.com>
Date: Tue, 15 May 2001 13:12:34 -0500
Message-ID: <3B017192.AC28A70F_at_lucent.com>
Date: Tue, 15 May 2001 13:12:34 -0500
Message-ID: <3B017192.AC28A70F_at_lucent.com>
Hello,
I have a funky query that I was wondering if anyone can give me a hand
with.
I have two tables, each table has a column that contains a random size number from 1 to 16 characters long. I need to build up a query that will select rows containing the shortest similar number between the 2 tables. To complicate matters worst, one of the tables stores some of its numbers prefixed by a 1, that is if the number is 658398, then this table will store it as 1658398 and the other table will store it as 658398.
Example:
Assume I have the following two tables:
Table 1 Table 2 NUM NUM ============= =============== 198798734 6784874 8409898 840 1874287430 98798734 1637608 6376084658
The Query must return:
840
98798734
637608
Any help will be greatly appreciated,
Jaime
-- Jaime J. Maiz IH 4F-310 mailto:jmaiz_at_lucent.com (630) 979-2088Received on Tue May 15 2001 - 20:12:34 CEST