Joining Tables

[Boycie92]

Hi

I am wondering if someone can help,

I have a table that has Product ID 1 and Product ID 2 (they both link to the same product)

I have a also have a Date Table.

I want to be able to merge them together so that every date within the date table has Product ID 1 & 2 beside them

Is this possible?

Thanks in advance,

Boycie92

[v-ljerr-msft]

Hi @Boycie92,

Could you post your table structures with some sample/mock data, and the expected result against the data? So that we can better assist on this issue. 

Regards

[vanessafvg]

@Boycie92 may i ask what you are trying to achieve exactly?    you could create a  conditional calculated ID column and give ita  new id where its product 1 or 2, but it would be helpful to know what  you want to do?

for example