MySql 怎么实现2张表 通过 表1中的数据 获得表2中的数据  其中表1 与表2有一个共同的属性 AnsID  怎么实现啊   
表 1
————————
Ques   |  AnsID
hello  |  1      

表2
————————
AnsID| Ans
1    | Hello

现在已知条件 是  知道表1中 的 Ques   hello   怎么得到 表2中 的 Hello   

   高手应该知道我问什么·····
  谢谢 高手 帮忙解决下·····

select 表2.ans from 表1 left join 表2 on 表1.ansid=表2.ansid where 表1.ques='hello';

string sql = "select answer.Ans from question left join answer on question.AnsID = answer.AnsID where question = 'Hello' ";

string sql = "select answer.Ans from question left join answer on question.AnsID = answer.AnsID where question = 'Hello' ";

这么写可以么？

string sql = "select answer.Ans from question left join answer on question.AnsID = answer.AnsID where question.ques = 'Hello' ";

 try
                {
                    string sql = "select answer.Ans from question left join answer on question.AnsID = answer.AnsID where question.Ques = 'Hello' ";
                    MySqlConnection conn = new MySqlConnection(Diction.Dao.ConnectionMySql.connection);
                    MySqlCommand commd = new MySqlCommand(sql, conn);
                    conn.Open();
                    MySqlDataReader dr = commd.ExecuteReader();
                    while (dr.Read())
                    {
                        MessageBox.Show(dr[0].ToString());
                    }
                }
                catch(Exception er)
                {
                    MessageBox.Show(er.Message);
                }


怎么输出结果啊   貌似这样输出结果不对 得不到 ···