New table with combining two columns from different tables and list every combination

Question

Hi gents,&nbsp;I have a date table (lets say 01st Jan 2023 to 31st Jan 2023) and a table with 3 names.&nbsp;Date Table:01.01.202302.01.2023...31.01.2023&nbsp;Name Table:JohnBobAlice&nbsp;Do you guys can give me a hint how to combine these two tables in two columns (date; name) to habe every date for every single name listed?&nbsp;Wanted solution:date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;name01.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;John01.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bob01.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Alice02.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;John02.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bob02.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Alice....31.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;John31.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bob31.01.2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Alice&nbsp;Hope you guys know what I mean 😉&nbsp;Any help would be appreciated.&nbsp;RegardsGerd

netmare · Accepted Answer

Got it: crossjoin was the missing syntax 😉

Forum Discussion

New table with combining two columns from different tables and list every combination

1 Reply

Related content

Tables combine

Data Combining Problem

Combining matrix

Combine Column

Dynamic RLS combination