Question

我有以下表格:

t2: c2-1(int), c2-2(int), c2-3(varchar), c2-4(varchar)  
t7: c7-1(int), c7-2(int), c7-3(int), c7-4(int), c7-5(varchar)

Now, values in c7-5 are like (abc, def, ghi, jkl . . .)
Now, values in c2-3 and c2-4 are like (abc.wav, def.wav, ghi.wav, jkl.wav . . .)

问题在于:我如何用斜面书写一个问询,从t 2 c2-2到t,c2-3或c2-4等于c7-5?

Basically, How to add the extension (.wav) to match the value in c2-3 and c2-4 ???

Answer 1

这是一种想法,你可以按照你的要求加以统一。

select *
from table1 t1, table2 t2
where t1.c3 = CONCAT(t1, .wav )

或更具体地说,您的表格名称

select t2.c2-2
from t2, t7
where t2.c2-3 = CONCAT(t7.c7-5, .wav ) OR t2.c2-4 = CONCAT(t7.c7-5, .wav )

我希望它能够发挥作用。