Remove duplicate data from one to many relation select query

[todaisies mysql]

Hello,

If i have 2 tables one header and one detail table like
table1
ID Code
1 X
Table2
Id Name
1 a
1 b
1 c

if i write a query "Select B.ID,B.Name,A.ID,A.Code from table1 A inner join Table2 B on A.Id=B.ID " the result would be like

1 a 1 X
1 b 1 X
1 c 1 X

How can i write a query to return data like this
1 a 1 X
1 b
1 c

Thanks