Can you define values in a SQL statement that you can join/union, but are not stored in a table outs
- by Mervyn
I'm trying to create a query and need to join against something that I can define values in without creating a table.
I'll attempt to describe what I'm trying to do:
table1 is joined on field a with table2 (titles for FK in table 1)
- Table1 has values outside of what exists in table2
- I want to add an additional 'table' to be unioned with…