I checked myself. It is valid. The first one should not return any rows. The second one is fine if it returns rows. Those would just be mailboxes no-one subscribes to. And no: you don't need to add rows for INBOXes for every user. Users cannot unsubscribe from them anyway.
Paul J Stevens wrote: > Jorge Bastos wrote: > >> But, I was checking and I have a lot of records without a mailbox, the >> select I did was: >> >> --- >> select *,(select count(*) from dbmail_mailboxes where >> mailbox_idnr=mailbox_id) as tot from dbmail_subscription having tot=0; >> --- >> And I have 286 records, that has no existing connection to dbmail_mailboxes. >> Can I safely delete this records from dbmail_subscriptions? >> >> >> And for dbmail_mailboxes: >> --- >> select *,(select count(*) from dbmail_subscription where >> mailbox_id=mailbox_idnr) as tot from dbmail_mailboxes having tot=0; >> --- >> I have 354 records that have no match in dbmail_subscription. >> >> My sql statements are correct, right? >> What can I do with this? > > Your sql smells funny. Is that valid JOIN syntax? If it is, I've never > seen it before. > > You better double check. > > > > > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
