I have two tables to which one in a query by selecting the "ID" and "NAME" from C #, I show it in a combobox, but some IDS are repeated, and when I select a name in the combo I select the first How can I solve this?
select campo1, campo2 from tabla1 union select camp1, campo2 from tabla2
This query is shown in a combobox, assuming we have:
id name
1 Arturo
1 Jorge
When I try to select Jorge in the combo he always takes me "Jose"