Is it possible to join these tables a view and combined columns?
2387
How to concatenate text from multiple rows into a single text string in SQL server?
49931
SQL Combine Two Columns in Select Statement
145844
Three tables join in SQL
156303
Performing Inner Join for Multiple Columns in the Same Table
7554
How do I create a cross reference table/query for my data?
26537
Possible to do a MySQL foreign key to one of two possible tables?
153310
Composite primary key from multiple tables / multiple foreign keys
158698
Adding columns to production tables
132463
Unioning two tables with different number of columns
102426
How Do I Combine Columns In Google Spreadsheets?
53145
Table with multiple merging
149449
Better query to select multiple columns into a single output column?
7908
Views and joining content types on specific field in Drupal 7
67785
Creating duplicate features based on many-to-one conversion of related table?
102396
Combine values from related rows into a single concatenated string value
7999
MySQL: View with Subquery in the FROM Clause Limitation
119480
Grouping two tables, one above the other