search

litedb-org / LiteDB.Studio

A GUI tool for viewing and editing documents for LiteDB v5
MIT License
809 stars 204 forks source link

How to join two tables? #61

Open findcaiyzh opened 3 years ago

findcaiyzh commented 3 years ago

I found the key word in SQL-Mode.xshd file.

But I couldn't figure out how to use it.

I tried: SELECT tablename.Price, url FROM tablename tablename.Price returns null.

also tried SELECT table1.Price, url FROM table1 JOIN table2 Got error: Unexpected token JOIN in position xx.