I have 2 series, bids and asks, indexed on time. Some timestamps are duplicated, indicating a price was updated more than once, but the timestamp resolution was too large to capture the differenc...

I have a list of people's ID and their first name, and a list of people's ID and their surname. Some people don't have a first name and some don't have a surname; I'd like to do a full outer join o...

I have the following select statement where I need to sum each task from table tbTasks and group them by projectId from table tbProjects in order to get a record like this: ProjectID = 1, ProjectN...

SQLite only supports INNER JOIN and LEFT JOIN. How do I do a FULL OUTER JOIN?

I'm comparing the behavior between SQL engines. Oracle has the behavior I would expect from a SQL engine for full outer joins: Oracle CREATE TABLE sql_test_a ( ID VARCHAR2(4000 BYTE), FIRST_...

I was trying to RIGHT JOIN two tables using this query: SELECT Persons.firstname, company.lastname FROM Persons RIGHT JOIN company ON Persons.firstname=company.firstname; which comes with this err...

This is driving me nuts. I have two tables that I am attempting to preform a join on, usersXstats and usersXstats_alltime. Both tables have the same columns: id, userId, statId, and value What I ...

I want to do a full outer join in MySQL. Is this possible? Is a full outer join supported by MySQL?

What is the difference between CROSS JOIN and FULL OUTER JOIN in SQL Server? Are they the same, or not? Please explain. When would one use either of these?

When working with data from multiple tables, there are a number of different ways that you can JOIN those tables, each of which alters the way matching columns are treated. You can also just pull t...

I have a question regarding a FULL OUTER JOIN in MySQL. I have two (or more tables): table1 table2 id value id value2 1 a 1 b 2 c 3 d 3 e 4 f I have used this query to get my join: SELECT * F...

Hi I have a table of entities which a user can select, I also have another table which contains information about a user's favourite entities. See: Table Entity: id | ... Table SavedEntity: id...

I've inherited a database that wasn't designed exactly optimally, and I need to manipulate some data. Let me give a more common analogy of the kind of thing I have to do: Let's say we have a Stude...

I need to join 4 tables based on a common primary key. If sqlite implemented full outer joins it might look something like this (with optimization not taken into account). SELECT S.pair, C.ball, P...

I am joining 2 tables -tbl1 and tbl2. Left join give all data from tbl1 which is in tbl2 or only on tbl1. Right join gives data from tbl2 which is don't exists in tbl1. I want to combine both resul...

I am building a WPF application that monitors a directory on the users computer. The app uploads files from the monitored directory and then saves off some information into a SQLite db. Part of the...

i need to join Header and Detail rows into one resultset: (sample DDL and inserts to follow): Orders: OrderID OrderDate CurrencyID BuyAmount BuyRate ======= ======================= ========== ...

Last week I was surprised to find out that sybase 12 doesn't support full outer joins. But it occurred to me that a full outer join should be the same as a left outer join unioned with a right oute...