Can you define values in a SQL statement that you can join/union, but are not stored in a table outs
Posted
by Mervyn
on Stack Overflow
See other posts from Stack Overflow
or by Mervyn
Published on 2010-05-21T18:47:28Z
Indexed on
2010/05/21
18:50 UTC
Read the original article
Hit count: 134
sql
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 table2 and then joined with table 1
Thanks
© Stack Overflow or respective owner
