Question...

I want to use the View Designer to create a Remote view to MSSQL that goes like this....


SELECT * FROM mydata WHERE condition_A AND ( condition_B OR condition_C )

Can the View Designer create a view using the parenthesis?? Or will I have to do this using SQL-Passthrough???

Thanks!!
Tommy