Hello I have this select where the last subselect will return a empty set and because of this the whole select will be empty. How can I change this syntax so I will have a row result even if the last select is empty?
SELECT * FROM (SELECT 1 AS t1, 2 AS t2) as t, (SELECT 3 AS t3) as s, (SELECT * FROM atc WHERE id = '1231222' LIMIT 1 OFFSET 0) AS s3; Thank you. --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com
