0

My Tables

ea_users

| id | email | phone | id_cellcarrier |

ea_cellcarrier

| id | cellurl |

I want:

| email | phone | cellurl |

My SQL statement

SELECT ea_users.email, ea_users.phone_number, ea_cellcarrier.cellurl 
FROM ea_users, ea_cellcarrier 
INNER JOIN ea_cellcarrier AS c2
ON ea_users.id_cellcarrier = c2.id

I get: Unknown column 'ea_users.id_cellcarrier' in 'on clause'

What am I doing wrong?

Martin
  • 22,212
  • 11
  • 70
  • 132
Craig Tucker
  • 1,051
  • 1
  • 11
  • 27
  • Don't mix the "lazy" join syntax with explicit `join`. choose one style or the other, but not both. – Marc B Sep 21 '16 at 19:42

2 Answers2

0

Your query should be rewritten

SELECT e.email, e.phone, c2.cellurl 
FROM ea_users e
INNER JOIN ea_cellcarrier c2
ON e.id_cellcarrier = c2.id

Also, it looks like the column name for ea_users is phone, right?

The One and Only ChemistryBlob
  • 7,864
  • 10
  • 36
  • 69
-1

This worked:

SELECT ea_users.email, ea_users.phone_number, ea_cellcarrier.cellurl 
FROM ea_users 
INNER JOIN ea_cellcarrier
ON ea_users.id_cellcarrier = ea_cellcarrier.id
Craig Tucker
  • 1,051
  • 1
  • 11
  • 27