I am just looking for example with the feature of showing List of Customers and List of orders. That means two tables two views (customers and orders).
If the user clicks on selected customer then the customers order list should show up in another view.
This is just a common example seen in other different programming language. Perhabs it is available here in this community - I will look around again.
The SQL statement is not a problem here. Thanks for your input Straker.