Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I didn't understand why i get this error : syntaxe error at or near select
here is the script :
The query runs on green plume and the connexion to the database works on qlikview
//connexion
SELECT "Concern. MDN", "offer"
FROM (SELECT SUBSTR(s.tt, 4, 😎 AS "Concern. MDN",
p.offer_name AS "offer",
Rank() over ( PARTITION BY s.tt ORDER BY o.valid_from DESC) AS last_offer
FROM p_edw.subber s
left join p_edw.subber_offer o ON o.subber_id = s.subber_id
AND To_char(o.valid_to, 'yyyy-mm-dd' :: text) = '9999-12-31' :: text
left join p_edffer p ON p.off_id = o.off_id) m
WHERE last_off = 1
exit script ;
What kind of error you are getting???
Please post your error msg??
try
SQL SELECT your query.
Regards,
Prashant
Hi,
In your from clause comment :: text and try/
FROM p_edw.subber s
left join p_edw.subber_offer o ON o.subber_id = s.subber_id
AND To_char(o.valid_to, 'yyyy-mm-dd' :: text) = '9999-12-31' :: text
left join p_edffer p ON p.off_id = o.off_id) m
Regards,
Prashant