你就贴张图,不好揣测你的意思啊
SELECT CATALOG.NAME.CATALOG.URL,CATALOG.UPTIME,CATALOG.PERSON FROM CATALOG CATALOG INNER JOIN FILE FILR ON
CATALOG.ID = FILE.ID 是这个意思吗?
-- 目录(mulu:表名) 文件(wenjian:表名),这是做查询的语句
select b.anme,b.url,b.uptime,b.person,a.name,a.url,a.uptime,a.personn from wenjian a left join mulu b on a.pid = b.id