Support:Database Cleanup: Difference between revisions
Content deleted Content added
imported>Kymara |
imported>Kymara |
||
Line 11:
SELECT null FROM rpobject WHERE characters.object_id=rpobject.object_id
) ORDER BY timedate;
</source>
Consider:
<source lang="sql">
SELECT * FROM characters
LEFT JOIN rpobject ON characters.object_id=rpobject.object_id
WHERE rpobject.object_id IS NULL
ORDER BY timedate;
</source>
| |||