re: #292 Alouette

I think I’ll wait for the Oracle guy to finish his meeting, in the meantime I can log in to the SQL Enterprise console and experiment with different SELECT commands.

I’m not sure if Oracle specifically allows this, but in most SQL implementations, you can put conditional statements in your JOIN clause. So it’d look something like:

SELECT * FROM TABLE1
JOIN TABLE2 ON TABLE1.stuff = TABLE2.stuff OR TABLE1.morestuff = TABLE2.stuff

In theory, I believe that should accomplish what you want.