1st post, new to this application and learning SQL
I have the following statement:
SELECT *
FROM `order`
INNER JOIN `products`
ON `products`.`id`=`order`.`itemname`
WHERE `order`.`id`='%ID%'
Below is my return:
ID itemname name
1 item1 1
2 item2 2
3 item1 3
I would like to see this:
ID itemname name
1 item1 item1
2 item2 item2
3 item1 item1
I’ve tried the SELECT text ‘products’.’itemname’ but get the following:
ID itemname name
1 item1 item1
2 item2 item2
3 item1
Thank you
Calvin
Return
Re: Return
Guess it was a system update/delay... Statement is working this morning. Please disregard