Howdy, Gordon.
This query is an attempt to replicate your items table with data just from
changelog table.
Could you please try it out?
Best,
Oliveiros
SELECT itm_id,usr_id_create, itm_date_create, usr_id_modify, itm_date_modify
FROM
(
SELECT a.itm_id, a.usr_id as usr_id_create, create as itm_d
I have a CMS with a table of items, and another table serving as a log
of operations performed on the items. The revelent table structure is
as follows:
items
itm_id | usr_id_create | itm_date_create | usr_id_modify |
itm_date_modify | .
itm_id is a serial primary key.
usr_id_* are the keys
