[thelist] subquerry instead of a join
Dan Berbece
dan_berbece at yahoo.com
Mon May 29 03:40:30 CDT 2006
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
More information about the thelist
mailing list