# DataFrames.leftjoin now working? leftjoin not defined

**URL:** <https://discourse.julialang.org/t/dataframes-leftjoin-now-working-leftjoin-not-defined/47667>\
**Category:** General Usage\
**Created:** [October 2, 2020, 10:00pm UTC](https://discourse.julialang.org/t/dataframes-leftjoin-now-working-leftjoin-not-defined/47667 "2020-10-02T22:00:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![psabela](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/psabela/32/17910_2.png) [@psabela](https://discourse.julialang.org/u/psabela)\
**Post date:** [October 2, 2020, 10:00pm UTC](https://discourse.julialang.org/t/dataframes-leftjoin-now-working-leftjoin-not-defined/47667/1 "2020-10-02T22:00:42Z")

</div>

julia\> using DataFrames

julia\> jobs = DataFrame(ID = [20, 60], Job = [“Lawyer”, “Astronaut”])  
2×2 DataFrame  
│ Row │ ID │ Job │  
│ │ Int64 │ String │  
├─────┼───────┼───────────┤  
│ 1 │ 20 │ Lawyer │  
│ 2 │ 60 │ Astronaut │

julia\> people = DataFrame(ID = [20, 40], Name = [“John Doe”, “Jane Doe”])  
2×2 DataFrame  
│ Row │ ID │ Name │  
│ │ Int64 │ String │  
├─────┼───────┼──────────┤  
│ 1 │ 20 │ John Doe │  
│ 2 │ 40 │ Jane Doe │

julia\> DataFrames.leftjoin(people, jobs, on = :ID)  
ERROR: UndefVarError: leftjoin not defined  
Stacktrace:  
[1] getproperty(::Module, ::Symbol) at .\Base.jl:26  
[2] top-level scope at REPL[4]:1  
[3] include\_string(::Function, ::Module, ::String, ::String) at .\loading.jl:1088

julia\>

---

<div class="post-metadata">

**Author:** ![pdeffebach](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pdeffebach/32/10320_2.png) [@pdeffebach](https://discourse.julialang.org/u/pdeffebach)\
**Post date:** [October 3, 2020, 12:12am UTC](https://discourse.julialang.org/t/dataframes-leftjoin-now-working-leftjoin-not-defined/47667/2 "2020-10-03T00:12:31Z")

</div>

What version of DataFrames are you using? Check with `] st`

---

<div class="post-metadata">

**Author:** ![psabela](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/psabela/32/17910_2.png) [@psabela](https://discourse.julialang.org/u/psabela)\
**Post date:** [October 3, 2020, 4:06am UTC](https://discourse.julialang.org/t/dataframes-leftjoin-now-working-leftjoin-not-defined/47667/3 "2020-10-03T04:06:18Z")

</div>

I have DataFrames v0.20.2.  
I realized that the syntax I was using is for version 0.21.7 – this is where the new leftjoin function is defined. In version 0.20.2 the syntax “join(people, jobs, on = :ID, kind = :left)”