I am getting in a knot and could do with some help.

I have a form using two tables, TICKET and CALLER.

These used a
SELECT T.X, T.Y, T.Z,
( SELECT A FROM CALLER WHERE T.Z = Z ) AS A
( SELECT B FROM CALLER WHERE T.Z = Z ) AS B
FROM TICKET T
WHERE T.X BETWEEN :A AND :A+1

and I can edit using RequestLive

but I can't search or order on A.

If I change to

SELECT T.X, T.Y, T.Z,
C.A, C.B
FROM TICKET T
JOIN CALLER ON T.Z = C.Z
WHERE T.X BETWEEN :A AND :A+1

I can search and order on A but I can't edit.

What should I be doing to get all three working?