Combobox display reference table2 and value Table1

[Benoit]

Hello,

I have problem to bind a combobox and a query with 2
tables.

This a little code I Use :

Dim myDR As SqlDataReader
Dim myQuery As String = "Select Table2.IdSoc,
Table2.Nom, Table1.IdListingP From Table1, Table2 where
Table1.idsoc = Table2.IdSoc"

cnCTI = New SqlConnection(ConnectionString)

Dim myCommand As New SqlCommand(myQuery, cnCTI)

cnCTI.Open()
myDR = myCommand.ExecuteReader()

cbo.DataSource = myDR
cbo.DisplayMember = "Table2.Nom"
cbo.ValueMember = "Table1.IdListingP"

How can I bind a combobox which display a value of a table
(Table2.nom) and give a value from another table
(Table1.ListingP) ?

Who can help me ?
Thanks...

BEN