I have solved the problem with following query syntax:

select orderno, orderdate, orderquantity, customerdate from orders, customers Where orders.customercode = customers.customercode and orderno = 1