CrossJoin

[madhuqliklondon]

Hi All,

I have 2 tables like below 

T1

_DateKey

T2

EmployeeNumber

I would like to join these two tables so which results in 

NewTable

_DateKey      EmployeeNumber

 20190101       123

[sunny_talwar]

Okay so what is the problem? What exactly is your question 

[anushree1 · Accepted solution]

Please check the attached, if this is what you are looking for