registry foreign keys

Bradley Giesbrecht pixilla at macports.org
Fri Dec 30 20:07:21 PST 2011


The registry 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;


Regards,
Bradley Giesbrecht (pixilla)






More information about the macports-dev mailing list