Linking table joins based on a condition

[janet_donbavand]

Is it possible to link tables with their joins based on a condition?

For example, is it possible to have a right outer join only when a particular value is X?

Thanks

Janet

[Former Member · Accepted solution]

Hi Janet, you can specify the condition base on particular value by using any of the following SQL commands as:

1. select * from employee e

    right outer join location l on e.empID = l.empID and e.particularValue = l.X;

2. select * from employee e

    right outer join location l on e.empID = l.empID

     Where e.particularValue = l.X;

[abhilash_kumar]

Hi Janet,

Do you have an example of what you're trying to do please?

-Abhilash

[janet_donbavand]

Hi Guys

Thanks I have solved it - I was trying to do something with the Database Expert but used Add Command and a variation of the above.