What kind of join will work to merge these two tables

I have table T1

date city vistors
---------------------
January 1 2020 NY 100
January 2 2020 NY 200
January 1 2020 SF 150
January 4 2020 SF 50

I have table T2

city state
----------
NY New York
SF Calfiornia

I want Matlab to create T3

date city vistors state 
---------------------
January 1 2020 NY 100 New York
January 2 2020 NY 200 New York 
January 1 2020 SF 150 California
January 4 2020 SF 50  California

[Image Analyst]

Make it easy for us to help you, not hard. Give us code to create the input tables T1 and T2.

TUTORIAL: How to ask a question (on Answers) and get a fast answer

What happens if you just simply try the various flavors of join? Maybe you'll stumble across the right one.

One non-join way is to simply use a for loop and ismember().

[alpedhuez]

Let me work on it.

Answer 1

[Jeff Miller]

Try

T3 = join(T1,T2,'Keys','City')