"AA2e72E" wrote ...

Try:

SELECT *
FROM CASH A,
(SELECT *
FROM CREDIT B,
REV C
WHERE B.?=C.?
AND B.?=C.?) B
WHERE A.?=B.?

* = all columns. If you want specific collumnd, specify ALIAS.ColName e.g.
A.Tktno etc as required.

I can't see that this solution would work. More than one column in
CREDIT is enough to break your code.

The WHERE clause specified the conditions to be satisfield for the table
JOINS.

Such join syntax has been superceded by SQL-92 INNER JOIN syntax e.g.

SELECT C.MyDataCol
FROM CREDIT B
INNER JOIN
REV C
WHERE ON B.MyKeyCol=C.MyKeyCol

I think even Oracle support this syntax now <g.

Jamie.

--