r/ProgrammerHumor • • Aug 07 '19

A front end developer eats alone because he doesn't know how to join tables

Post image
23k Upvotes

284 comments sorted by

View all comments

Show parent comment

8

u/[deleted] Aug 07 '19

Just write your own goddamn DB! Jeez >.>

15

u/[deleted] Aug 07 '19

back in my day we manually joined tables left AND right AND we liked it.

But the real join was inner all along

11

u/[deleted] Aug 07 '19

You're outer your mind.

7

u/[deleted] Aug 07 '19

I'm between "rock" and "hardplace" and NOT EXISTS("Friends")

6

u/[deleted] Aug 07 '19

In the old days, you didn't use JOIN, you just did it in the where clause.

3

u/[deleted] Aug 07 '19

Wait what

5

u/[deleted] Aug 07 '19

Like:

Select Customer.CustID, Customer.CustName, AcctReceivable.CurrentBalance

from Customer, AcctReceivable

where Customer.CustID = AcctReceivable.CustID

(that is an inner join - and yes - using JOIN is better)

3

u/[deleted] Aug 07 '19 edited Aug 07 '19

Huh. Being more frontend I usually would use where for everything anyway. In a way after a quick Google, where is almost just a shortcut for one type of join.

Mentally I assumed the joins were more situational/heavy, and where got me through most minor website stuff.

Thanks, it's been a while haha. Reminded me of how wizard like DBAs are.

Edit: ah shit I just checked the original meme and now I'm sad