How to get data check from multiple tables?

Databases
1

Hi,
I have multiple table
Table -1
order_no name
1 raj

table -2
order_no name
1 raj

table 3
order_no name
1 raj

table 4
order_no name
1 raj

table 5
order_no name
1 raj

I want a query to check if the id (one) is present in all tables or not,
i create this.

select order_no from prepress, press, postpress, qc, binding, dispatch where order_no=prepress.order_no AND order_no=press.order_no AND order_no=postpress.order_no AND order_no=qc.order_no AND order_no=binding.order_no AND order_no=dispatch.order_no
but the ambiguous error for order_no.

how to achieve this can anyone suggest me?
thanks

2 
SELECT prepress.order_no 
  FROM prepress
INNER
  JOIN press
    ON press.order_no = prepress.order_no 
INNER
  JOIN postpress
    ON postpress.order_no = prepress.order_no 
INNER
  JOIN qc
    ON qc.order_no = prepress.order_no 
INNER
  JOIN binding
    ON binding.order_no = prepress.order_no 
INNER
  JOIN dispatch where 
    ON dispatch.order_no 
 WHERE prepress.order_no = 1
3

Hi,
thanks for reply
have done lil bit of correction in your code, let me check, if it works.
Thanks

4

hi r937,
thanks its working man.

5

hey thanks, man, what was the correction??

6

Your code

 JOIN dispatch where 
    ON dispatch.order_no 
 WHERE prepress.order_no = 1

mine after change

JOIN dispatch 
    ON dispatch.order_no = prepress.order_no 
 WHERE prepress.order_no = 1

remove where and add for comparison of dispatch.order_no.

Overall i must thank to solving my problem.

thanks