有两张表,一张为GUEST代表旅客,一张为PREORDER代表订单,现在我想要用户输入GUEST旅客的名字GNAME就能查询到PREORDER订单,如何做到?
PREORDER中有一个字段GID作为外键关联到GUEST中的主键GID,但是旅客的名字GNAME却什么都不是,只是GUEST中的普通字段而已

我觉得我已经描述的很清楚了吧,代码还需要贴嘛? 求大神解惑呀..

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

  
  


    
    
    
    
    
    
    
    
      


    
    
    
        
    
        
    
    
    
    
    



    
    


    
    
    
    
    
    
    



    select p.*,g.gname,r.rt_name from preOrder p left join guest g on p.gid=g.gid left join roomtype r on p.rt_id=r.rt_id where po_id=#{po_id}




    
        
        
            and poCreateTime between #{beginDate} and #{endDate}
        
                
    



    
        order by
        
            
                po_id
            
            
                poCreateTime
            
        
        
            ASC
        
        
            DESC
        
    




    select * from
    (select row_number() over(

= #{pageno} and rn <= #{pagesize} ]]>

    
    
    ) rn,p.* from preOrder p
    
    



select count(po_id) from preOrder