how can i join a table to another table in mysql code example
Example: mysql join two tables
SELECT user_id, user_name
FROM users
UNION
SELECT organization_id, organization_name
FROM organizations
SELECT user_id, user_name
FROM users
UNION
SELECT organization_id, organization_name
FROM organizations