Recent content by MartinH

Ah yes, didnt notice i was in the wrong section. What would be the correct SQL please? Thanks, Martin

Im struggling to get ADD-INTERVAL to work. I get Syntax error. I'm not sure what is wrong with the syntax, could someone assist please? Select Distinct "A"."MATDB"."MT-CODE", "PUB"."BILLS"."CL-CODE", "A"."MATDB"."DATE-OPENED", "A"."CLIDB"."FULL-DERIVED-NAME", "TELEPHONES2"."TEL-NUMBER" As...