SELECT     dbo.TblGhest.ID, dbo.TblGhest.sh_member, dbo.TblGhest.sh_vam, dbo.TblVam.name_vam, dbo.TblVam.price_vam, dbo.TblVam.date_vam, 
                      dbo.TblVam.count_ghest, dbo.TblVam.karmozad, dbo.TblVam.state_vam, dbo.TblMember.name_member, dbo.TblMember.date_hesab, 
                      dbo.TblMember.price_first, dbo.TblMember.state, dbo.TblMember.tel, dbo.TblMember.address, dbo.TblMember.type_member, 
                      dbo.TblGhest.price_ghest, dbo.TblGhest.date_ghest, dbo.TblGhest.shghest, dbo.TblGhest.state_ghest, dbo.TblGhest.remain_vam
FROM         dbo.TblGhest INNER JOIN
                      dbo.TblMember ON dbo.TblGhest.sh_member = dbo.TblMember.sh_member INNER JOIN
                      dbo.TblVam ON dbo.TblGhest.sh_vam = dbo.TblVam.sh_vam