CODEWITHSUNDEEP
sqlite
Adrian Preuss
Adrian Preuss

Reputation: 3113

SQLite compare two tables and fetch the actual row

I have two SQLite tables with same fields:

Fields

The first table named as FB_Config_Trace and the second FB_Settings.

FB_Config_Trace will be filled by the script to fetch the latest values from an configuration file, FB_Settings will be set by an user.

Sample Data:

FB_Config_Trace:

FB_Config_Trace Data

FB_Settings:

enter image description here

How i can fetch the latest rows/entries by given Time?

Sample

Upvotes: 1

Views: 68

Answers (1)

forpas
forpas

Reputation: 164089

Join FB_Settings to FB_Config_Trace with a LEFT join like this:

SELECT COALESCE(c.ID, s.ID) ID,
       s.Key,
       CASE WHEN c.ID IS NULL THEN s.Value ELSE c.Value END Value,
       COALESCE(c.Time, s.Time) Time
FROM FB_Settings s LEFT JOIN FB_Config_Trace c 
ON c.Key = s.Key AND c.Time > s.Time

Upvotes: 1

Related Questions