,select ..for update改不了数据删了还会出来，怎么用rowid呀？
select t.booking_no ,t.booking_id,
o.CONTRACT_NO,
t.suppler_name,
t.contact_user,
t.contact_tel,
t.deliver_address,t.check_date_time,
b.item_no,b.item_name,b.item_brand,b.item_model,b.qty,b.packages,b.gw,b.item_notes,t.fbill_name,s.phone,o.booking_date
from CHECK_ORDER t, booking_order_entry b, sys_user s,booking_order o
where t.booking_id = b.booking_id and t.fbill_name = s.user_name and t.booking_id = o.id and b.voided=0
and t.id=8652 order by item_no
你想实现什么功能，把表结构贴出来，你需要怎样的查询结果，光这么一段sql谁也看不出来