IBM Mainframe Forum

Right now I'm just messing around in SPUFI. Eventually I am going to either execute this from a job or from a COBOL program.

I'm dealing with a very complex query that is touching on multiple tables and the same table in multiple ways to get the data that I want.

So I have, say 6 SELECT statements. I would like to split these up so that I can reference them in the outer most SELECT as Flat files. Can I do that?

SELECT *
FROM (INCLUDE??) Flat.File.A
LEFT JOIN (INCLUDE??) Flat.File.B
WHERE.....

Thanks in advance for any help!

DK