SQLITE Replace Column IDs with NAMES from SEPERATE TABLE in same DB

Question

I have a sqlite database avalible here => https://www.dropbox.com/s/9cn093ns3ot2cik/drinks.db?dl=0

I'm trying to show ( or replace?) the drinks.glass_id with its proper name from glasses.name

I have tried

select drinks._id DID, 
       drinks.glass_id GID,
       glasses.name GNAME,
       glasses._id GIDD 
from drinks DRNKS
     join glasses GLS
     on drinks.glass_id = glasses._id

What is wrong??
I have spent several hours looking this up. I have read these links and still cant figure it out.

http://community.spiceworks.com/topic/242166-sql-query-help-convert-category-id-to-the-text-name

Replacing a pulled SQL ID value with its name from another table

How to replace fetched values with another column while querying with SQL Server 2008 R2

how to get name from another table with matching id in another table?

What is wrong? Do you get an error? – juergen d Jan 10 '15 at 06:20 — juergen d, Jan 10 '15 at 06:20

score 1 · Answer 1 · answered Jan 10 '15 at 06:23

1

If you specify an alias for your tables then you have to use it everywhere

select d._id DID, 
       d.glass_id GID,
       g.name GNAME,
       g._id GIDD 
from drinks d
join glasses g on d.glass_id = g._id

answered Jan 10 '15 at 06:23

juergen d

201,996
37
293
362

That didn't work. `Error: near "join": syntax error` – Tony Jan 10 '15 at 06:52
The one you just posted. – Tony Jan 10 '15 at 18:06
Im using database browser portable. Heres my personal copy Im using https://www.dropbox.com/s/mlpflj54zga6rd6/DatabaseBrowserPortable.rar?dl=0 – Tony Jan 10 '15 at 20:41

SQLITE Replace Column IDs with NAMES from SEPERATE TABLE in same DB

1 Answers1