你可以这样查 select * from goods,category where goods.c_id==category.c_id 我不知道你的具体情况,给你个列子,这样就可以查询多表了,希望对你有帮助
select tba.field1 as tba_field1, tbb.field1 as tbb_field2from tba as tbajoin tbb as tbb on tba.refid = tbb.id