VS 2010 SQL Query 2 Tables - Getting Info Loaded In RTBOct 16, 2011
I have 2 tables. I'm getting info from table1 which is loaded in an rtb.
]Dim cmd_info As New MySqlCommand("SELECT kan_info FROM kan_info WHERE kan_id= '" & kt_id & "'", conn)
reader = cmd_info.ExecuteReader
beslag_kanton_info.Text = _
"RB_REF: " & vbNewLine & _
"KT_REF: " & vbNewLine & vbNewLine & _
This works great, but I need to add extra info after "RB_REF:" and "KT_REF:" (e.g: RB_REF: 12345 / KT_REF:6789) Those values are located in another table. How do I change the code/query so it also get the necessarily records from that table? Obviously there is a column "kan_id" with same values. I can't merge the tables btw.