select * from table3 where field3 = (select field2 from table2 where field2 = (select filed1 from table1 where filed1 = '你的查询条件'))
如果查询出的结果集不是唯一的话，把 = 换位 in 查询就行了
