SELECT * FROM jos_vm_category ,jos_vm_category_xref
WHERE jos_vm_category.category_id
AND jos_vm_category_xref.category_child_id=jos_vm_cate gory.category_id;