Link to home
Start Free TrialLog in
Avatar of Kyle Hamilton
Kyle HamiltonFlag for United States of America

asked on

MYSQL query syntax

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';

Open in new window

Then under each result, I would like to list the results from another query:

SELECT * FROM iq.comment where item_id = 2294;

Open in new window

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,
Avatar of Ess Kay
Ess Kay
Flag of United States of America image

FROM iq.item i LEFT JOIN
  iq.comment c ON = c.item_id

where i.grouping_id='334' && i.class='D';

Open in new window

if you want all columns from item and specific columns from comments

SELECT i.*, c.item_id, c.columnb, c.columnc, c.col......(insert comuns here)
Avatar of Kyle Hamilton



can I select only certain columns from the item table as well?
Avatar of Ess Kay
Ess Kay
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
also if any column has a space you must enclose it in brackets

SELECT i.[my weird fieldname]
luvly, thank you!