Re: 诚心请教 (SQL) => Try This Please:# Database - 数据库
n*f
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!!
阿弥陀佛
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!!
阿弥陀佛