Query Problem

From: KIN Wong <kinwong_at_tdl.com.hk>
Date: 1998/01/22
Message-ID: <34C6A932.17AD@tdl.com.hk>#1/1

Hello all,

I have some question on the Sql Statement.

The following query return zero records.

Query1

---

Select a.comp, b.tel from tab_comp a, tab_tel b where a.key1 = b.key1 and a.key2 = b.key2

but add a rtrim() function to the query, it works

Query2

---

Select a.comp, b.tel from tab_comp a, tab_tel b where a.key1 = b.key1 and a.key2 = rtrim(b.key2)

first I wonder if there is some blank space in the b.key2 field , so I update the Field like that:

update tab_tel set key2= rtrim(key2)

after update, Query1 still doesn't work.

Please mail me at
kinwong_at_tdl.com.hk

Thanks in Advanced Received on Thu Jan 22 1998 - 00:00:00 CST