n****f 发帖数: 905 | 1 For Oracle 8.1.7 try this:
SELECT tb.*
FROM ta, tb
WHERE tb.NAME = SUBSTR (ta.NAME, 1, LENGTH (tb.NAME))
For Access 2000 try this:
SELECT TB.name, TB.DT
FROM TA, TB
WHERE TB.name = MID(TA.name,1,LEN( TB.name));
Please let me know if you have any questions.
Good Luck!!
阿弥陀佛 |
|