Use the command table to create a sql query. Open a new, blank database. At the very top of your data tables is Add Command. Select Add Command and click on the right arrow to move it to the right window pane. A blank window will open to add your sql query. Here is an example of a query I did to pull the real time data and history data:
SELECT "F4211"."SDDOCO", "F4211"."SDDCTO", "F4211"."SDLNID", "F4211"."SDMCU", "F4211"."SDADDJ", "F4211"."SDIVD", "F4211"."SDPDDJ", "F4211"."SDLITM", "F4211"."SDITM", "F4211"."SDAEXP", "F4211"."SDUPRC", "F4211"."SDUORG", "F4211"."SDUOM", "F4211"."SDSOQS", "F4211"."SDGLC", "F4211"."SDLTTR", "F4211"."SDNXTR", "F4211"."SDRCD", "F4211"."SDVR01", "F4211"."SDSRP3", "F4211"."SDPA8"
FROM "JDEDTA"."F4211" "F4211"
(Put your selection criteria in the where line)
WHERE "F4211"."SDMCU"='*' AND
("F4211"."SDDCTO"='*' OR "F4211"."SDDCTO"='*')
Union All
SELECT "F42119"."SDDOCO", "F42119"."SDDCTO", "F42119"."SDLNID", "F42119"."SDMCU", "F42119"."SDADDJ", "F42119"."SDIVD", "F42119"."SDPDDJ", "F42119"."SDLITM", "F42119"."SDITM", "F42119"."SDAEXP", "F42119"."SDUPRC", "F42119"."SDUORG", "F42119"."SDUOM", "F42119"."SDSOQS", "F42119"."SDGLC, "F42119"."SDLTTR", "F42119"."SDNXTR", "F42119"."SDRCD", "F42119"."SDVR01", "F42119"."SDSRP3", "F42119"."SDPA8"
FROM "JDEDTA"."F42119" "F42119"
WHERE "F42119"."SDMCU"='* AND ("F42119"."SDDCTO"='*' OR "F42119"."SDDCTO"='*')