0

I have 2 tables with names tbl1_items and tbL2_propeties, here 1 item can have one or many properties. So I have joined them with a one-to-many relationship. whenever I tried to access data with SQL query joins it showed two rows. I need to show the data in one row with multiple properties.

skjalal
  • 19
  • 2
  • Hm, you get 1:n, so 1 row joined a group of n. You could `GROUP_CONCAT` all columns from the joined table. EDIT: which is not so nice. – cottton Oct 26 '21 at 13:28

0 Answers0