Quering an array from another table

Question

I have this query:

SELECT `beacons`.*, `blocks`.`ID` AS `blockID` FROM (`beacons`) LEFT JOIN `blocks` ON `blocks`.`StoreID` = `beacons`.`Major` WHERE `beacons`.`Major` = '2' ORDER BY `beacons`.`Minor` desc

When I do it I get reptitive information from the table beacons

What I want to get instead - one row with an array of blocks ID:

Could you explain further/clarify? Read this a couple of times and it's very hard to understand what you're actually asking? — jbutler483
– jbutler483, Commented Sep 4, 2014 at 16:24

jbutler483 · Accepted Answer · 2014-09-04 16:30:35Z

1

SQL Joins Your question (i think) refers to INNER JOIN, which is shown below (amongst others). It also comes with a little bit of SQL for each one :)

answered Sep 4, 2014 at 16:30

jbutler483

24.7k11 gold badges100 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mopsyd · Accepted Answer · 2014-09-04 16:26:05Z

0

Look into the INNER JOIN function.

answered Sep 4, 2014 at 16:26

mopsyd

1,9223 gold badges20 silver badges31 bronze badges

3 Comments

Itay Over a year ago

Thank you. now I got this Query: SELECT beacons.*, blocks.ID AS blockID FROM (beacons) LEFT JOIN blocks ON blocks.BeaconID = beacons.ID WHERE beacons.ID = '2' ORDER BY beacons.Minor desc

Itay Over a year ago

This query makes many rows with the whole info of the beacon again and again, and for each time the only change is the block ID, instead of this repetitive rows I want an array of all of the block IDs in one line - instead of many rows. is that possible?

mopsyd Over a year ago

You are going to have to format your query results into the desired structure after you retrieve them through your codebase.

Collectives™ on Stack Overflow

Quering an array from another table

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related