Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Cobol > ProCobol Outer ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 15 Topic 4108 of 4115
Post > Topic >>

ProCobol Outer join

by jeff <jmoore207@[EMAIL PROTECTED] > May 8, 2008 at 06:58 AM

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?




 15 Posts in Topic:
ProCobol Outer join
jeff <jmoore207@[EMAIL  2008-05-08 06:58:32 
Re: ProCobol Outer join
"Michael Mattias&quo  2008-05-08 09:24:01 
Re: ProCobol Outer join
jeff <jmoore207@[EMAIL  2008-05-08 07:40:38 
Re: ProCobol Outer join
Robert Jones <rjones0@  2008-05-08 10:54:52 
Re: ProCobol Outer join
jeff <jmoore207@[EMAIL  2008-05-08 11:01:48 
Re: ProCobol Outer join
Robert Jones <rjones0@  2008-05-08 13:56:21 
Re: ProCobol Outer join
Robert <no@[EMAIL PROT  2008-05-08 18:36:04 
Re: ProCobol Outer join
Robert <no@[EMAIL PROT  2008-05-08 20:40:41 
Re: ProCobol Outer join
"Pete Dashwood"  2008-05-09 15:09:26 
Re: ProCobol Outer join
Robert <no@[EMAIL PROT  2008-05-08 20:48:29 
Re: ProCobol Outer join
"Pete Dashwood"  2008-05-09 15:11:11 
Re: ProCobol Outer join
Robert <no@[EMAIL PROT  2008-05-08 22:55:34 
Re: ProCobol Outer join
"Michael Mattias&quo  2008-05-09 08:17:58 
Re: ProCobol Outer join
"Pete Dashwood"  2008-05-10 12:57:31 
Re: ProCobol Outer join
Robert <no@[EMAIL PROT  2008-05-08 22:25:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed May 14 17:06:03 CDT 2008.