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
