Re: Report with data from 2 unrelated siblings

Thanks Charlie.

Unless the SQL is really complex I find SQL much easier to maintain than procedural code.

On 10 November 2018 16:46:49 GMT-04:00, Charlie-gm ccbibleman@gmail.com wrote:

I'd recommend building it up procedurally. Performance might be a little slower but the end result will be far easier to maintain.

-Charlie

On 11/9/2018 10:27 AM, Frank Cazabon wrote:

...

Hi,

CREATE CURSOR Merchants ; (MerchantID i,; MerchantName c(10))

[snip]

...

I need to create a report like this (the email and template columns must be side by side): *Merchant** *     *Email** *     *Template* Freddie

[excessive quoting removed by server]