Search results for query: *

I think i solved the problem :) select distinct A.* from A inner join B ON A.Col1 = B.Col1 union select distinct A.* from A inner join C ON A.Col1 = C.Col1

Hi I want to join three tables, Lets say A, B and C. I want all data from the A table that have at least one row matching in B or C. That Is I dont want the rows from A that do not have an match in eiter B or C, but all the other. Now the Query looks a bit like this. Which gives me the wrong...

Here is the solution to my problem, I didn´t do it in SQL since I´m more comfortable in VB. But I guess that it is easy for a SQL programmer to convert this to SQL. Dim dateFrom1 As Variant Dim dateTo1 As Variant Dim dateFrom2 As Variant Dim dateTo2...

If we start with the statement: the first intervall should be either fully or partly within the second date intervall, and in both intervals the Todate can be NULL. we can have the intervalls DateFrom1 - DateTo1 and DateFrom2 - DateTo2. if DateTo1 or DateTo2 are NULL then the intervall...

How do I compare two dateintervals (from-to date), the first intervall should be either fully or partly within the second date intervall, and in both intervals the enddate can be NULL. Do not want to set the Null dates to an imaginary date if this can be avoided. Can it be done by SQL not using...