mysql关联查询怎么在查询软件中一下就能查询到所有的关联数据，修改的时候也方便，对比数据

set @orderid=10428; set @airs=(select group_concat(orderAirId) From t_ticket_order_air where orderId=10428);#机票主表select *from t_ticket_flightorder where orderid=@orderid;#机票订单项表select *From t_ticket_order_air where orderId=@orderid;#机票联系人关联select *from t_ticket_order_item_tourist where orderItemId in ( @airs);#机票联系人关联select *From t_ticket_order_tourist where airId  in ( @airs);#机票结算明细select *From t_ticket_amount_summary where id=(select summaryId from t_ticket_flightorder where orderid=@orderid);#机票支付记录select *From t_ticket_other_517 where itemId in ( @airs);select *From t_ticket_other_trade where itemId =@orderid;#订单跟踪记录select *From t_ticket_order_trace where orderid=@orderid;

只要定义变量就行，后面就修改变量就ok了。不用每次换个订单。就需要改所有的里面的数据。这样子方便。