How to Create the Crystal reports using selected fields from Two tables. I mean how to Write the Query For crystal report?
if you need to write a free hand SQL in crystal reports, you can use "Add Command" option
after you make your connection , expand it , you will see an option in the top called "Add Command"
click and select add, and then write your free hand SQL, but you have to take care of the syntax of the connection supports.