Subject: | Re: Crosstab
| Date: | Wed, 18 Dec 2019 16:39:34 +1000
| From: | Bernie van't Hof <onrequest@somewhere>
| Newsgroups: | pnews.paradox-dos
|
Well I'm not much better!
Just about sorted crosstab (at least conceptually) and made an awkward
discovery in the process.
CREATE TABLE `Answer` AS SELECT ... seems innocuous enough.
But I hadn't noticed before that it brings NULL/NOTNULL settings from
SELECT columns into the new table. The benefits are obvious, but is
different to pdox which generates the Answer table unkeyed. Ho Hum :(
- Bernie
> Glad to see some activity on this forum, Bernie. But, I've no SQL
> expertise,
|