Subject | Editing a JOIN |
---|---|

Author | Lester Caine |

Post date | 2001-09-27T17:04:36Z |

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?

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?