[HaBo]

SQL-Befehl: Dokumentation

SELECT `products_id` , `products_name`
FROM `products_description`
LEFT JOIN `products` ON `products.products_id`
WHERE `products_description` LIKE '%Portofrei%'
AND `products_status` = '1'
LIMIT 0 , 30

MySQL meldet: Dokumentation
#1052 - Column 'products_id' in field list is ambiguous

SELECT 
    products_id,
    products_name
FROM
    products_description pd

LEFT JOIN 
    products p
ON
    p.products_id=pd.products_id

WHERE
    p.products_description  LIKE '%Portofrei%'
AND
    pd.products_status = '1'

LIMIT 0 , 30

SQL-Befehl: Dokumentation

SELECT products_id, products_name
FROM products_description pd
LEFT JOIN products p ON p.products_id = pd.products_id
WHERE p.products_description LIKE '%Portofrei%'
AND pd.products_status = '1'
LIMIT 0 , 30

MySQL meldet: Dokumentation
#1052 - Column 'products_id' in field list is ambiguous

SELECT 
    p.products_id,
    p.products_name
FROM
    products_description pd,
    products p
WHERE
    p.products_id = pd.products_id
AND
    p.products_description  LIKE '%Portofrei%'
AND
    pd.products_status = '1'

LIMIT 0 , 30

SELECT pd.products_id, pd.products_name
FROM products_description pd, products p
WHERE p.products_id = pd.products_id
AND pd.products_description LIKE '%Portofrei%'
AND p.products_status = '1'
LIMIT 0 , 30

SELECT pd.products_id, pd.products_name
FROM products AS p

JOIN products_description AS pd
ON p.products_id = pd.products_id

WHERE pd.products_description LIKE '%Portofrei%'
AND p.products_status = '1'

#1052 - Column 'products_id' in field list is ambiguous