mysql select question

[CrosRoad95]

is possible to select from mysql using 1 select which output like this in

{
 ["name"]="mynickanem",
 ["other_column"]="kldsjskldjf",
 ["licenses"]={
 	   {
      	["name"]="driver",
     	["ban"]=0,
    	}
    	{
      	["name"]="gun",
      	["ban"]=0,
     	 }
    }
}

from 2 tables "accounts" and "licenses"

[NeXuS™]

Try this:

 

local nrQuery = dbQuery(dbConnection, "SELECT * FROM accounts UNION SELECT * FROM licenses")
local rQuery = dbPoll(nrQuery, -1)
outputChatBox(toJSON(rQuery))

I dont know if UNION works here.

[Om.]

Instead or outputChatBox and JSON, You can use iprint function to print the table

[3aGl3]

I don't think a UNION is quite what he wants, furthermore I doubt it'll even work, considering that this is one of the UNION operators requirements:

Quote

The columns must also have similar data types

This would be more what he wants:

SELECT * FROM players WHERE player_id=? JOIN licenses ON players.player_id=licenses.player_id

...however it'll not give you exactly what you are looking for. Read more on JOINs here: W3Schools