One table unique, another duplicate - JOIN - result duplicated

[johnseito]

I have table a with unique x and table b with duplicated y.



I INNER JOIN the two table and the result is also duplicated of what is in table b.
Instead of having it duplicated (table B show twice). Can it show once and the second value as NULL or blank.

How can I write an SQL statement to do this. Below is my simple SQL statement

SELECT *
FROM a INNER JOIN b ON a.[x]=b.[y];

[June7]

Why are there duplicate y? Are there other fields in both tables? Try:

SELECT DISTINCT x, y FROM a INNER JOIN b ON a.x = b.y;

Post example raw data and desired output if you need more assistance.

[johnseito]

it's a long story and a complicated scenario. I'll try to explain it as best as I could.

I have table A with one unique field only.
I have table B with also one unique field1 - and a bunch of other fields, field2, 3, 4, 5, 6, etc all the way to 10)

I did two queries - with a join on field1 from table A and table B and did union all to these two queries. The result is one query go on top of the other one.
One query is to take field2, and the other query is to take field3 and did so consecutively to all the fields.
Because I did union all, it duplicated the ID field. so now I have two same id, one id represent field2 from one query and another id represent field3 from second query.

I then did a join to a third table (table C). In this join I only wanted what is matched to table C.
However because of the duplicated ID from union all, now I have repeated data from table C.
How do I query to only show one value and the second duplicated value as a NULL or blank.

It gets more complicated than this - when I did union all to both query in the join between table A and table B -
some of the field in there I only wanted to show a particular field and not consecutive fields, however these fields are also duplicated with the same id.
I didn't want to explain it on top is because it gets harder to explain it (don't want confusion). I also wanted from result with no dups but just one showing
and the other one as blank or NULL.

I don't know if this can be done.

Hope is clear, if not I will revise.

[June7]

Nope, not clear. Provide data.

If you want to attach db, follow instructions at bottom of my post.

[johnseito]

Sorry for the delay.

Attached is the db and the sample image.
Besides shifting the fields around, this is the scenario.
How can I get field, for example 14, 15 and so on, the second line of the repeated field1 (id) which is also the second query of the union all query to be blank ?

Field14 have 33 repeated twice, one on top and one again on the bottom.
The bottom one to be blank.

[aytee111]

This can only be done by creating a report - there is a property on text boxes to Hide Duplicates. Otherwise you can create a temporary table and populate it thru some sort of VBA function which checks for duplicates.

[johnseito]

Ok, thanks for your advice.