How to SELECT from 2 table and get their value using mysqldatareader

See more:

C#

Good day Ma'am and Sir. I want to select cause from table 1 and select address from table2 where unique_id = @uniqueid. Both tables have primary key called unique_id. and get the their value using DataReader.

What I have tried:

using(MySqlConnection con = new MySqlConnection(connString))
           {
               consp.Open();
               string clientid = "009";
               MySqlDataReader reader;
               MySqlCommand com = new MySqlCommand("SELECT FROM ",con);
               com.Parameters.AddWithValue("@uniqueid,"clientid);
               reader = com.ExecuteReader();
               while(reader.HasRows && reader.Read())
               {
                 string cause;
                 string address;
                 cause = reader.GetString(reader.GetOrdinal());
                 address = reader.GetString(reader.GetOrdinal());
               }

           }