ProCobol Outer join

I am having a problem with a left outer join when I add conditionals.

Select
A. vehicle,
B.Vehicle,
B.acct,
B.MOYR,
B.Trancode
from Table1 A, Table2 B
where A.vehicle=B.vehicle(+)
and B.acct='1234'
and B.MOYR = '0502'
and B.trancode='80'
order by a.vehicle

I need all a.vehicles for all vehicles to come back in the cursor
regardless. Any ideas?
.

Relevant Pages

  • Re: ProCobol Outer join
    ... vehicle, ... from Table1 A, Table2 B ... Then you can't us the conditionals that way, ...
    (comp.lang.cobol)
  • Re: ProCobol Outer join
    ... from Table1 A, Table2 B ... select vehicle, null, null, null, null ... (select b_vehicle, acct, MOYR, trancode, DISTINCT vehicle from ...
    (comp.lang.cobol)
  • For Next Each??
    ... is given for each cell of the grid. ... On a second sheet of the Excel workbook the grid is ... column C is an If statement that determines the vehicle ... table2 is a non-linked table that is in Access. ...
    (microsoft.public.access.modulesdaovba)
  • Re: ProCobol Outer join
    ... vehicle, ... from Table1 A, Table2 B ... a=foo(+) means a=foo or foo is null ...
    (comp.lang.cobol)
  • Re: ProCobol Outer join
    ... vehicle, ... from Table1 A, Table2 B ... Nevertheless, a very elegant solution. ...
    (comp.lang.cobol)