You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
7 lines
299 B
7 lines
299 B
src: |
|
|
SELECT t_ucd.oid AS ucd_tarifs_id,
|
|
t_ucd_tarifs.date_debut AS ucd_tarifs_date_debut,
|
|
t_ucd_tarifs.date_fin AS ucd_tarifs_date_fin
|
|
FROM base.t_ucd
|
|
JOIN pmsi.t_ucd p_ucd ON p_ucd.code::text = t_ucd.code
|
|
JOIN pmsi.t_ucd_tarifs ON p_ucd.oid = t_ucd_tarifs.ucd_id;
|