samedi 3 janvier 2015

SQLite with JOIN

I've got a pretty simple query that works just fine as is. But I need to add some fields from another table that has a match in one of the resulting fields. Here's the query that works:



select *
from "Time Track"
where Username = "JustMe"
and WeekNum = "1"


"Recnum" is the linking field between "Time Track" and "Pro Track". From the "Pro Track" table I need to pull two fields called "TKNum" and "Type". Anyone feel like helping me out?


Aucun commentaire:

Enregistrer un commentaire