diff options
| -rw-r--r-- | docs/useful-sql.md | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/docs/useful-sql.md b/docs/useful-sql.md index cfcc2ca..6efeedd 100644 --- a/docs/useful-sql.md +++ b/docs/useful-sql.md @@ -21,10 +21,10 @@ WHERE it.entry = XXXXX; ### Find which RLTs an item is in ```sql -SELECT rlt.entry, it.entry, it.name +SELECT rlt.entry, it.name FROM `reference_loot_template` rlt JOIN `item_template` it ON rlt.Item = it.entry -WHERE it.entry = XXXXX; +WHERE rlt.item = XXXXX; ``` ### Find which creatures share a RLT |