Odd Query Error in Mariadb

0 votes

1 answer

28 views

                          This query works without an error (I am running this query in HeidiSQL and 10.5.22-MariaDB)

    SELECT concat(d.fname, ' ', d.Lname) AS Name, 
           d.EMail, 
           d1.Number 
    FROM orders d
    LEFT OUTER JOIN phones d1 ON d.EMail = d1.Number
    where (d.EMail  '')
    HAVING d1.Number IS NULL;

If I enclose it in (), I get an error (was getting an error when I used it
as a subquery which is why I tried this.

    (
    SELECT concat(d.fname, ' ', d.Lname) AS Name, 
           d.EMail, 
           d1.Number 
    FROM orders d
    LEFT OUTER JOIN phones d1 ON d.EMail = d1.Number
    where (d.EMail  '')
    HAVING d1.Number IS NULL;
    )

 The error is

> SQL Error (1064): You have an error in your SQL syntax; check the
> manual that corresponds to your MariaDB server version for the right
> syntax to use near '' at line 6


                        

Asked by JohnBell (1 rep)

Nov 13, 2023, 04:29 PM
Last activity: Nov 14, 2023, 08:32 PM

Odd Query Error in Mariadb

Related Questions