Thank you very much Chris.

'EXISTS' worked for me yesterday but it's no more working today weird!

I...

Hello Chris

Basically what I want is A interserction B which is A AND B. But in my case I can not do that because I can't write in the query "select propertyId where...

Thank you very much for your trials. I found out that the problem was in a loop I was using in my code. So the synthax '%"+villaName+"%' is right.

Good luck...

Thank you for your help.

'%'+villaName+'%' didn't work!

villaName is a string where I put the name of the villa 'palais mehdi' for example.

My query is working in query analyser, but when I put '%"+villaName+"%' in...

Thank you very much Jonathan.

It's a good idea, I'll try it!

Thank you very much for those information.

Can you give me an example how to include COUNT_BIG(*)  in my query?

Thank you beforehand

Zineb