d"Database Events" and simple join possible?

Scripting Forums AppleScript | Mac OS X
#1

Using database events, is it possible to query a sqlite database with with a simple join?

For example

select t1.col3, t2.col4 from t1, t2 where t1.col1 = t2.col2

#2

No. If you want to query a SQLite database, one alternative is to use my SQLite Lib2 script library, available here:

https://latenightsw.com/support/freeware/

#3

thanks. I ended up just using a do shell script and passed a string to execute the command in sqlite3 and store the results in a csv file in /tmp, then I just read the file into a list.

Still, the library looks interesting and I appreciate the pointer. Many thanks.