如何让ASP.NET Query适用于ASP.NET表适配器？

I have a query with a sub query in the select that needs to get a value from a certain table if it exists. I don't want to paste the query here for business reasons, but here's a simplified example of what I am trying to do:I have a query with a sub query in the select t