Lester,

I think missing Comma between two inline selects is a typo only.

Anyway, if you use your column A in OrderingItmen as number (in your case 4)
ordering should work.

If you use same inline selects for your where clause instead of A then
searching should working, too (at least to me, cause I use this contruct
very often).

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Lester Caine" <lester@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, September 27, 2001 7:04 PM
Subject: [IBO] Editing a JOIN


> 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?
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>