Can someone show how to create a dynamic where clause in Sybase?
I have a select statement with a where clause.
But based on the count of rows returned from a table I want to add one more condition....
if the count is 0 then no additional condition needs to be added to the where clause
and if the count > 1, then I want to add the values returned by another select query in the where clause condition.