我无法从工作中访问图像URL。但我想我可能已经理解了你需要的东西。您可以在查询中添加更多列。

I can't access the image URL from work. But I guess I may have understood what you need. You can add more columns to the query.

SELECT	ISNULL(CDESC,BDESC) 
FROM	TBLA JOIN TBLB 
ON		TBLA.AID = TBLB.AID
		LEFT JOIN TBLC 
ON		(TBLB.BID = TBLC.BID AND TBLB.AID = TBLC.AID)
ORDER BY TBLC.CID DESC,TBLB.BID DESC