Subquerys dont work as expected

[peon501]

I see statements like this dont work

SELECT (SELECT Name from SomeKindOfTable as sm WHERE sm.Id=m.Id) FROM Main as m

Is it bug or not supported ?

[peon501]

ps I use indexeddb database.

[mathiasrw]

Hmm. Does this work in other databases? Looks like you are doing a join without doing a join.

I would be really awesome if you could provide an example with the data in sm and m together with the expected output...

Have you tested with its not indexeddb?

[peon501]

SELECT HardServiceId, h.ClientId, h.Name, h.Date AS RegDate, h.Duration AS EndTime, h.VisitDate AS PlanDate, h.Address, h.City, (SELECT op.Name FROM Options_Details as op WHERE op.OptionDetailId = h.ServiceId) AS Type,

(SELECT op.Name FROM Options_Details as op WHERE op.OptionDetailId = h.StatusId) AS Status FROM HardService as h

before I used sql.js https://github.com/kripken/sql.js/

now Iam doing

JOIN Options_Details as opse ON opse.OptionDetailId=h.ServiceId JOIN Options_Details as opst ON opst.OptionDetailId=h.StatusId

because subselects dont work

javascript code: alasql('ATTACH INDEXEDDB DATABASE database;USE database;', [],function(){ // Select data from IndexedDB alasql.promise(sql_statement)) .then(callback); }); sql_statement is SQL select above

[peon501]

Joins are slow if you only need 1 column. I dont want to join whole table to other table. Normly all sql engines allows you to do that like i showed.

[peon501]

I could be wrong about speeds :) in internal. but anyway subselect should work 😄 .