C_sharp_beaver
asked on
FULL OUTER JOIN
I try to create query inside Excel VBA
Table looks like
Param_1 Param_2 Param_3 Month Value
1 2 3 1 5
1 3 3 1 6
1 3 4 1 7
2 2 3 2 5
2 3 3 2 6
1 3 4 2 7
Query looks like
SELECT TBL1.Param_1 as Param1_1, TBL1.Param_2 as Param2_1, TBL1.Param_3 as Param3_1, TBL1.Month as Month_1, TBL2.Month as Month_2, TBL1.Value as Value_1, TBL2.Value as Value_2 FROM Table1 as TBL1 FULL OUTER JOIN Table1 as TBL2 ON TBL1.Param_1 = TBL2.Param_1 AND TBL1.Param_2=TBL2.Param_2 AND TBL1.Param_3=TBL2.Param_3 WHERE TBL1.Month = 1 AND TBL2.Month = 2
Method "Open" of Object "Recordset" failed
When I use LEFT or INNER join I get some results but I need FULL OUTER JOIN
I already tried to create copy of table and join them - same result
Please advise
Table looks like
Param_1 Param_2 Param_3 Month Value
1 2 3 1 5
1 3 3 1 6
1 3 4 1 7
2 2 3 2 5
2 3 3 2 6
1 3 4 2 7
Query looks like
SELECT TBL1.Param_1 as Param1_1, TBL1.Param_2 as Param2_1, TBL1.Param_3 as Param3_1, TBL1.Month as Month_1, TBL2.Month as Month_2, TBL1.Value as Value_1, TBL2.Value as Value_2 FROM Table1 as TBL1 FULL OUTER JOIN Table1 as TBL2 ON TBL1.Param_1 = TBL2.Param_1 AND TBL1.Param_2=TBL2.Param_2 AND TBL1.Param_3=TBL2.Param_3 WHERE TBL1.Month = 1 AND TBL2.Month = 2
Method "Open" of Object "Recordset" failed
When I use LEFT or INNER join I get some results but I need FULL OUTER JOIN
I already tried to create copy of table and join them - same result
Please advise
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
UNION does not help
as you can see I have more complex ON restrictions. By some reason does not help. Does not collaps but amount of records like INNER JOIN
as you can see I have more complex ON restrictions. By some reason does not help. Does not collaps but amount of records like INNER JOIN
ASKER
I agree that FULL OUTER JOIN cannot be created. But I need way around
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This databasejournal thing is good. Additional problem due to complex query I'm running out AMOUNT OF LINES inside VBA query
Testing...
Testing...
C_sharp_beaver,
It would help if you would post the SQL that you are testing. (Also, please put it in the Code section and attach it to the response. ;-)
It would help if you would post the SQL that you are testing. (Also, please put it in the Code section and attach it to the response. ;-)
ASKER
Advice about code is perfect but cannot follow due to security restrictions
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
C-sharp_beaver,
Advice about code is perfect but cannot follow due to security restrictions
You already posted some code . . . if that code is what your code is like, then posting a similarly obfuscated clip of SQL indicated your test SQL would probably suffice. Please note that, since we have no idea what you are writing and testing, we have no idea whether your test SQL is anywhere near correct. ;-)
Advice about code is perfect but cannot follow due to security restrictions
You already posted some code . . . if that code is what your code is like, then posting a similarly obfuscated clip of SQL indicated your test SQL would probably suffice. Please note that, since we have no idea what you are writing and testing, we have no idea whether your test SQL is anywhere near correct. ;-)
Hi,
Use only Outer Join
Use only Outer Join
ASKER
We trying to work around limitation of specific product.
As soon as application progress let's say to SQL Server our life will become easy
Life is perfect in perfect world (c)
As soon as application progress let's say to SQL Server our life will become easy
Life is perfect in perfect world (c)
ASKER