MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();

version()

8.0.30

0

I have the following statement:

SELECT tableA.*, tableB.* FROM tableA, tableB WHERE tableA.userUUID = ? AND tableB.uuid=tableA.tableBUUID
So when a record in table A has a valid tableBUUID and the tableBUUID exists in tableB then the query runs file. But when I removed the tableBUUID from table B without removing it from the record in tableA then the query returns nothing (Which is obviously expected)

I am wondering how I can change the query so that even if the tableBUUID does not match anything, the query will still return what it can even if its nothing/ blank columns from tableB?

Thanks all

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0

I have the following statement:

SELECT tableA.*, tableB.* FROM tableA, tabl' at line 1

CREATE TABLE tableA (
  userUUID varchar(100)
);

CREATE TABLE tableB (
  uuid varchar(100)
);

INSERT INTO tableA
VALUES
(UUID());

INSERT INTO tableB
SELECT userUUID FROM tableA

Records: 1  Duplicates: 0  Warnings: 0

SELECT * FROM tableA

userUUID

2f8f4624-39df-11ed-a8d5-fe7e7bef3c60

SELECT * FROM tableB

uuid

2f8f4624-39df-11ed-a8d5-fe7e7bef3c60

SELECT tableA.*, tableB.* FROM tableA, tableB 
  WHERE tableB.uuid=tableA.userUUID

userUUID
uuid

2f8f4624-39df-11ed-a8d5-fe7e7bef3c60
2f8f4624-39df-11ed-a8d5-fe7e7bef3c60

DELETE FROM tableB
SELECT tableA.*, tableB.* 
  FROM tableA 
  LEFT JOIN tableB ON tableB.uuid=tableA.userUUID

userUUID
uuid

2f8f4624-39df-11ed-a8d5-fe7e7bef3c60
null