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,
Kyle
DatabasesSQL
Last Comment
Kyle Hamilton
8/22/2022 - Mon
Ess Kay
SELECT * FROM iq.item i LEFT JOIN iq.comment c ON i.id = c.item_idwhere 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)