Return

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
calvin
Posts: 2
Joined: 2023-04-04 11:36

Return

Post by calvin » 2023-04-06 21:04

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

calvin
Posts: 2
Joined: 2023-04-04 11:36

Re: Return

Post by calvin » 2023-04-07 12:52

Guess it was a system update/delay... Statement is working this morning. Please disregard

Post Reply