Lets build SQL query which will return the resultset where tables orders and customers joined by orderno field: