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

[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.