The MacPorts registry.db table "dependencies" has a foreign key column "id" referencing ports.id.
How can this query not be empty? SELECT dependencies.* FROM dependencies LEFT JOIN ports ON dependencies.id = ports.id WHERE ports.id IS null; With this query I get result rows so I have records in my "dependencies" table with a dependencies.id value that DOES NOT match any ports.id value. Regards, Bradley Giesbrecht (pixilla) _______________________________________________ macports-dev mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-dev
