Re: Stored Procedure Strangeness?

} I'm running a stored procedure that executes: } } "select * from A, outer B where A.FK = B.PK" } } If A.FK is not null, I get success. If A.FK *is* null, I get (in DB-Access) } a whole set of (expression)'s but no data. } } Are there known bugs with stored procedures using outer joins? } } OnLine 5.01.UC1, SunOS 4.1.3 } } -- } In-Real-Life: John Bossert, Thalatta Corporation, (+1 206.455.9838) Known bug. Outer joins do not currently work in SPL. Try a union select. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 375-5222 (Work) Address: 700 Airport Blvd. #300 (415) 882-9728 (Home) Burlingame, CA 94010-1937 Fax: (415) 375-5019 ----------------------------------------------------------------------