Every derived table must have its own alias (sql & php)

Question

SELECT COUNT(*) AS Total FROM (
        SELECT *
        FROM `list_lazada` WHERE product_name LIKE '%$search%' 
        UNION All
        SELECT *
        FROM `list_simulation` WHERE product_name LIKE '%$search%' 
    )

running sql "Every derived table must have its own alias"

please help?

just add an alias after the subquery parenthesis – Thomas G Nov 18 '16 at 14:06 — Thomas G, Nov 18 '16 at 14:06

score 2 · Answer 1 · answered Nov 18 '16 at 14:05

2

Provide an alias name for sub-query

SELECT COUNT(*) AS Total FROM (
        SELECT *
        FROM `list_lazada` WHERE product_name LIKE '%$search%' 
        UNION All
        SELECT *
        FROM `list_simulation` WHERE product_name LIKE '%$search%' 
    ) t1

Hope this should solve your problem.

answered Nov 18 '16 at 14:05

Viki888

2,686
2
13
16

It Works, Thanks you so much :) – Seteven Wei Nov 18 '16 at 14:12

Every derived table must have its own alias (sql & php)

1 Answers1