jdesai wrote:

In many cases the result does not show up

query work but no result come up.

A query could return null if there are no records matching the query condition. If you want to properly test your queries, insert some records into the tables yourself.