I’m testing power of your query engine. I tryed to write a query with a sub-query into the FORM but it looks like no effects. I made a mistake or is it impossible to do that?
FROM tab1 JOIN (SELECT * FROM tab2 WHERE 1) as t
Otherwise I also tryed to create a variable butit gives back a syntax error:
SET @avgPrice = (SELECT AVG(price) FROM tab WHERE 1);
SELECT * , @avgPrice
Do you suggest anything to have the same effect of sub query?