I'd like to export the combined results of two queries to CSV. The export to csv is not an issue.
I need help writing the query which will give me all the results I need. I'm using MySQLWorkbench.
I have some rows from this query:
SELECT * FROM iq.item where grouping_id='334' && class='D';
Then under each result, I would like to list the results from another query:
SELECT * FROM iq.comment where item_id = 2294;
where 'item_id' is the 'id' from the first query. there are multiple rows for each row in the first query.
I'm guessing these have to be joined?
Both tables have a date_created column, which I don't want to duplicate, as well as a content column, which is named differently. One is called 'description' and the second is called 'content'. I would like these two to become one column.
Please let me know if I need to clarify anything else.
Thanks in advance,