[thelist] subquerry instead of a join

[Dan Berbece]

Hello!
First of all, I'd like to greet everyone since this is
my first use of TheList!
Now, on to business

I must rewrite the following querry:

select * from table2, table1
where table2.base= table1.base and
substring(table1.dest, 1, table2.dig_len) =
table2.digit

using a subquerry rather than a join. This has prooven
to be a little tricky for me, since I am kinda' new to
SQL. :D
Can anyone please give me a hint?

table2:
base
digit
dig_len
cost

table1:
base
dest

Can anyone please help ?

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com