I have a the following in a Database

table1 : order
table2 : ship

order fields : userid,orderid etc...
ship fields : userid,orderid etc..

now i want a query such that.. select all orders from order table where order.userid = 1 and order.orderid = ship.orderid

i did this in VB6 but gave error

Code:
select * FROM order WHERE order.userid = 1 and order.orderid = ship.orderid
gives error

please tell me correct statement..