We need table definitions as CREATE TABLE statements, some sample data in the form of INSERT INTO statements and expected results.

See the first article linked in my signature line to see how to post this question effectively.