Recordset from more than one query

[bartolini_tt]

Hi All,



Can You help me with resolve below case ?

I'm creating in VBA a recordset from two Queries and I received an error when I try to read first value from the recordset.

Mentioned statement:

SQL = "select nr_PL1 as ver1, outstanding_PL1 as ver2, DPD_PL1 as ver3 from table1 where table1.id = " & search & " and nr_PL1 Is Not Null "
SQL = SQL & "select nr_PL2 as ver1, outstanding_PL2 as ver2, DPD_PL2 as ver3 from table1 where table1.id = " & search & " and nr_PL2 Is Not Null "

When i try to read first value i receive an error: Syntax error in query expression...

I'm pretty sure that there is an issue when i try to connect second sql with the first one but i need Your professional opinions.
How Can I create this recordset from two or more queries.
PS: Method by using " & _" at the ond of line can't be used because the statement is over 25 lines.

Many Thanks in advance !.

[ranman256]

you forgot UNION....

SQL = SQL & "UNION select nr_PL2 as ver1, outstanding_PL2 as ver2, DPD_PL2 as ver3 from table1 where table1.id = " & search & " and nr_PL2 Is Not Null "

[bartolini_tt]

Many Thanks ranman256 !

All The Best For You