Forum Discussion

Locken's avatar
Locken
Frequent Visitor
6 years ago

Joining tables

Hi,

 

I have 2 tables that I need to join through an intermediary table; really not my area of expertise so was hoping someone could put me on the right track. The tables are as follows:

 

Table 1 has the column 'test_run_id'

Table 2 has the column 'tag_id'

 

Would I be able to create the intermediary table using UNION, or do I need something else?

 

It'll be 1 test run id to many tag ids, for reference.

 

Apologies if I butchered any terminology!

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    So does the second table also have a test_run_id column? Or does the tag_id column somehow include the corresponding test_run_id?