i've been working on a mysql for a few days now, and none of the mysql joins seems to be sufficient. i need more than a right join. i need like a super right join. normally a right/left join will join elements and bring across all rows from the right/left joined table.
i need every row in the right/left joined table to be joined with every row in the original table! :o
how is this possible?
i'll report back soon as i delve deeper into the mysql abyss.