Hello,
SELECT
concat( 'sfax49',
TRIM(LEADING '0' FROM vorwahl),
replace(telnummer,'-',''),
'#'
)
FROM crm_adress
was hat das hier...
SELECT
comment
FROM.
WHERE db_name = 'bbcCRM'
AND table_name = ''
AND column_name = '(db_comment)'
mit dem zu tun?
Dein Fehler in dieser Abfrage ist einfach: Der Tabellenname hinter FROM fehlt, stattdessen steht dort ein Punkt.
MfG
Rouven
--
-------------------
"I wish it need not have happened in my time" - "So do I, and so do all who live to see such times. But that is not for them to decide. All we have to decide is what to do with the time that is given us." -- J.R.R. Tolkien: "The Lord Of The Rings: The Fellowship Of The Ring"
-------------------
"I wish it need not have happened in my time" - "So do I, and so do all who live to see such times. But that is not for them to decide. All we have to decide is what to do with the time that is given us." -- J.R.R. Tolkien: "The Lord Of The Rings: The Fellowship Of The Ring"