Tag Info

New answers tagged

0

I had this error and found that the cause was the partition holding the database file having no disk space free.


0

your first query is standard SQL (the parentheses are redundant, only needed by MS-Access) and should work just fine in SQLite, with or without the parentheses: SELECT Message.messageContent, Message.messageDateTime FROM Message INNER JOIN ( Contact INNER JOIN contact_m2m_message ON Contact.contactID = ...


1

The documentation says: PRAGMA index_info(index-name); This pragma returns one row each column in the named index. The first column of the result is the rank of the column within the index. The second column of the result is the rank of the column within the table. The third column of output is the name of the column being indexed. > pragma ...


2

Try this select used_for_lookup.id, used_for_lookup.datetime, fid_table.fid_important_string, did_table.did_important_string from used_for_lookup join fid_table on fid_table.id = used_for_lookup.fid join did_table on did_table.id = used_for_lookup.did where datetime between '2014-10-09' and '2014-10-11';


1

The following SQL performs the join you need. select used_for_lookp.id ,used_for_lookup.datetime ,fid_table.fid_important_string ,did_table.did_important_string from used_for_lookup join fid_table on fid_table.id = used_for_lookup.fid join did_table on did_table.id = used_for_lookup.did


0

"Find all the Users of a particular workspace that are not associated with a specific task" You need to move the AND user_task.task_id=? condition from the WHERE clause to the related ON. (I think you also have a typo. ON user_task.task_id = Task._id should be ON user_task.user_id = User._id): SELECT User.* FROM User INNER JOIN user_workspace ON ...



Top 50 recent answers are included