Hi!
For example I have a simple query (draft untested):
SELECT
a.x1 AS "a-x1",
a.x2 AS "a-x2",
b.x1 AS "b-x1",
b.x2 AS "b-x2"
FROM
a,
b
WHERE
a.x1 = b.x1
AND a.x2 <> b.x2
it's simple, but I want to see only the a.x1, a.x2, and b.x2 fields in the dbgrid (
except b.x1).
Is it possible anyhow with SQLite command or only solution with add required columns to the dbrig manually?