Understanding the use of curly braces and “OJ” in a SQL query?

MySQL supports this alternative syntax for an Outer Join However that does not mean that it should be used It can be problematic to have RDBMS-specific code if at some point you need switch to another RDBMS Googling around, it appears that MySQL doesn't support this syntax for more than 2 joins Aside: Another non-ANSI-compliant issue with the code is the subsequent joins This is a quick stab at an ANSI-compliant version (not tested): SELECT DISTINCT ra. Folder_id, pd. Id, f.Name, pd.

Descriptor_text FROM permission_descriptors pd LEFT JOIN permission_descriptor_users pdu ON pdu. Descriptor_id = pd.Id LEFT JOIN role_allocations ra ON pd. Id = ra.

Permission_descriptor_id LEFT JOIN folders f ON ra. Folder_id = f. Id WHERE pdu.

Descriptor_id IS NULL AND pd.Id 1 ORDER BY ra. Folder_id Other notes: For inequality! Will work, but is preferred.

MySQL supports this alternative syntax for an Outer Join. However that does not mean that it should be used. It can be problematic to have RDBMS-specific code if at some point you need switch to another RDBMS.

Googling around, it appears that MySQL doesn't support this syntax for more than 2 joins. Aside: Another non-ANSI-compliant issue with the code is the subsequent joins. This is a quick stab at an ANSI-compliant version (not tested): SELECT DISTINCT ra.

Folder_id, pd. Id, f. Name, pd.

Descriptor_text FROM permission_descriptors pd LEFT JOIN permission_descriptor_users pdu ON pdu. Descriptor_id = pd. Id LEFT JOIN role_allocations ra ON pd.Id = ra.

Permission_descriptor_id LEFT JOIN folders f ON ra. Folder_id = f.Id WHERE pdu. Descriptor_id IS NULL AND pd.

Id 1 ORDER BY ra. Folder_id; Other notes: For inequality! = will work, but is preferred.

Thanks for the clarification! – Scott Jul 20 at 21:52.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.