Thanks for that. I added WHERE namespace != 'CURRENCY'
As some of the stocks have the same ticker as some currency, so show up as a duplicate. On Mon, Aug 10, 2026 at 11:56 PM Wm Tarr <[email protected]> wrote: > I don't think you can do it in gnc but here is some SQL that does it > > === > > with m_cnt as ( > > select mnemonic, count(*) as cnt > > from commodities > > group by mnemonic > > having cnt > 1 > > ) > > select namespace, mnemonic > > from commodities > > where mnemonic in (select mnemonic from m_cnt) > > ; > > > === > > Wm > > On 2026-08-10 01:36, Fred Tydeman wrote: > > > > Anyone know of a way to find stocks in more than one Namespace? > > > > > _______________________________________________ > 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. > _______________________________________________ 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.
