Recent content by Bro

what do you mean?

Hi I have two queries which are slightly different. One of the queries takes way too much time and resources and I'm wondering if anyone could explain me why, and if possible, how to fix it. This query is slow. Unseen Movies SELECT "General Info"."Title", "Additional Info"."Subtitles" FROM...

Thank you very much! Works like a charm!

Hi I have two tables. both tables contain an id column (Integer) with the same values. Table1 contains the data I want. Table2 contains one column with boolean values. So this is what I want (though it doesn't work at all) FROM [Table1] WHERE [Table2].[BooleanVolumn]=true So I want all the...

Hi, thanks for helping me out. It should look like this:

Hi I need three tables with a relationship between their primary id columns. The first two tables: CREATE TABLE [Table2] ([id] INTEGER PRIMARY KEY); CREATE TABLE [Table3] ([id] INTEGER PRIMARY KEY); and then I need the last SQL query to create Table1 with column id related to the column id...