[URGENT] conditional outer join?

I have a situation that I would describe as needing a Conditional Outer Join. The situation is concerns 2 tables. Table A has unique records in it. Table B may or may not have a matching record. No problem. I can use where a.id = b.id (+) . However, if table B has a record, then I need to check the value of a certain other variable for compliance. If compliance is met, then I need to include the record. I am using an Oracle database with Concur Technologies Seeker HR product. I mention this because I am constrained from making one table to feed another, etc. It is not impossible, but not convenient to code, as these queries are dynamic and change with many users. This is inline code that works within Concur's own script language. Basically I have to use existing tables to pass SQL code directly to Seeker and then Seeker handles the output. So, using pseudo code, it would look like this:

If exists(a.id & b.id & b.date = somedate) output; else if exists(a.id) & !exists(b.id) output;

Please reply to my e-mail address as this is really urgent. Thanks in advance for any and all help!

gaylen.fraley_at_mail.sprint.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 11 2000 - 00:00:00 CDT