I wrote the same query still is not runing and trainer is going very fast

SQL
1

I wrote the same query still is not runing
and trainer is going very fast

image
image1157×601 30.5 KB

1 Like
2

Hi,

For the error I can’t tell anything wrong per se in the query.
The error message is incomplete so it is difficult to tell.

Could you maybe copy the full message here ?

Any typo in names ?

For too fast, just pause as much as you need or even go back.

I sometimes do that too.

Cheers.

3

1 Screenshot 2024-02-02 012118
1 Screenshot 2024-02-02 0121181366×711 79.4 KB

this is additional screen shot
I cross check too many time still its given the same error

4

This is additional info.

1 Like
5

from what I can see in the 2 screenshots, it looks like you have not selected the database where the order items table is.
Try

SELECT *
FROM sql_store.order_items oi
JOIN sql_inventory.products p
ON oi.product_id = p.product_id;

1 Like
6

THis is worked
I also did the spelling mistek
Thanks so much

7

No problem! Happy to help