On 2025-12-07 21:59, Adrien Monteleone wrote:
Asking a chatbot for code is not reliable. That you *may* get
something that *appears* to work is a happy accident of probabilities,
but I'd never rely on it.
There are plenty of SQL references out there to figure out how to
write a query. Writing them is itself nearly an art form, and you'll
only learn by doing.
I'd rely on the SQL table reference from the GnuCash wiki and a good
SQL reference or tutorial site.
Regards,
Adrien
On 12/7/25 11:50 PM, Fred Tydeman wrote:
List of "stocks" in more than one Trading account:
Google Chrome AI came up with:
SELECT
c.mnemonic,
COUNT(a.guid) AS trading_account_count
FROM
accounts a
INNER JOIN
commodities c ON a.commodity_guid = c.guid
WHERE
a.account_type = 'TRADING'
GROUP BY
c.mnemonic
HAVING
COUNT(a.guid) > 1;
Again, it found several duplicates. However, some of them are stocks
that have the same symbol as a currency.
Currencies are also commodities.
And I'll second Adrien's excellent suggestion.
Cheers
Cam
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
