-1

I am working in SQL server and have two tables in my database, I am attaching their sample screenshots below:

Table 1:table_1

And the second table is as shown in the image below:

Table 2:table_2

I am trying to assign all the Korean language values from table_1 which are in Action_Item_in_Korean column to each value in the Asset_No column so my output should look like as shown below:

Output:Output

Each Asset_No should repeat 8 times because there are 8 values in table_1 that need to be updated. , I know that simple update query is not enough to display the output as I need, searched alot but so far unable to design a solution for this.

Steve Smith
  • 3
  • 1
  • [Please do not upload images of code/data/errors when asking a question.](//meta.stackoverflow.com/q/285551) Sample data should really be provided as DDL and DML statements, but any data should at least be supplied as either a markdown table or well formatted tabular `text`. – Thom A Jul 28 '22 at 10:43
  • Noted, but these table had korean language symbols which I tried copy here but could not get the desired formatting – Steve Smith Jul 28 '22 at 11:05
  • @SteveSmith The language of the text appears to be irrelevant. Do you think it is? – SMor Jul 28 '22 at 11:25

1 Answers1

0

You tagged "cross join" and that seems like it satisfies your goal. A simple example is:

select <columns you desire> 
from dbo.[table 1] as t1 cross join dbo.[table 2] as t2
order by ...
;
SMor
  • 2,830
  • 4
  • 11
  • 14