nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL link to create one table

Katieee

I want to link 2 tables together through sql to use in my report. If I wanted to link the two tables up - would it be possible to do it this: if the name of T_Table exists in column 2 of table B could they be linked them up through that? (column data and table name) I know my sql and I don't think you can but I thought it was worth asking incase there actually is some kind of ninja way to do this 
 
 
T_Table | B Table
 | column 1 column 2
 |
info | data T_Table
info 1 | data 1 A Table
info 2 | data 2 C Table

Find more posts tagged with

Comments

JFreeman

So you are wanting to conditionally perform a join in the query for the data set depending on the data available within a column in one of the tables?

Hans_vd

you could use a literal:
<pre class="_prettyXprint">
WITH t_table_view AS (
SELECT 'T_Table' AS table_name,
info
FROM T_Table
)
SELECT *
FROM t_table_view
join B_Table
on (t_table_view.table_name = B_Table.column2)</pre>

Katieee

@ Jesse - In answer to your question I believe so yes- I do think what Hans provided would help 

@Hans Would I use all of that statement in order to get my desired results? Thank you for posting that as I didn't think it was possible

Hans_vd

<blockquote class="ipsBlockquote">Would I use all of that statement in order to get my desired results?
 
</blockquote>
 
Not sure if I understand the question, but I think the answer is "yes" :-)