How to combine results of two queries into a single dataset

by

Here is an example that does a union between two completely unrelated tables: the Student and the Products table. It generates an output that is 4 columns:

select
        FirstName as Column1,
        LastName as Column2,
        email as Column3,
        null as Column4
    from
        Student
union
select
        ProductName as Column1,
        QuantityPerUnit as Column2,
        null as Column3,
        UnitsInStock as Column4
    from
        Products

Obviously you’ll tweak this for your own environment…

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Is it possible to write single query on two table which are not connected to each other?
  3. T-SQL split string
  4. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  5. How can I get column names from a table in SQL Server?
  6. Conditional WHERE clause in SQL Server
  7. How can I select the first day of a month in SQL?
  8. Split function equivalent in T-SQL?
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. Multi-statement Table Valued Function vs Inline Table Valued Function
  11. Select statement to find duplicates on certain fields
  12. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  13. Where value in column containing comma delimited values
  14. Parse comma-separated string to make IN List of strings in the Where clause
  15. SQL query to split column data into rows
  16. T-SQL split string based on delimiter
  17. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  18. Compare DATETIME and DATE ignoring time portion
  19. Split function in SQL Server 2008
  20. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  21. SQL “between” not inclusive
  22. Can I set ignore_dup_key on for a primary key?
  23. Using PIVOT in SQL Server 2008
  24. Which SQL query is faster? Filter on Join criteria or Where clause?
  25. How can I group by date time column without taking time into consideration
  26. When using GETDATE() in many places, is it better to use a variable?
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. Cumulative Total in MS Sql server [duplicate]
  29. SQL Server SELECT INTO @variable?
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment