Consult everybody I like into the infinite loop,

Column in table 1: number array (nvarchar (MAX))
Table 2 column names: number (nvarchar (50))

 
SELECT T1. *, T2 * FROM [1] as T1 LEFT JOIN [2] as T2 ON T1. [number] arrays like '%' + T2. [number] + '%' 

And I want to ask this design table 1 and table 2 associated together is there a problem? Or affect the query efficiency of what?

CodePudding user response:

You on what you should not pick up their common column directly like

CodePudding user response:

reference 1st floor captain can't program reply:

you on what you should not pick up their common column directly like the

is that there is no common column ah

CodePudding user response:

Select a. *, b. *
From a
Left the join b on Anderson, d=b.i d

Where Anderson d like (' % XXXX % ')

This, the condition cannot be put inside connection relation table of keywords,

CodePudding user response:

reference morliz son hin reply: 3/f

select a. *, b. *
From a
Left the join b on Anderson, d=b.i d

Where Anderson d like (' % XXXX % ')

This condition can't put inside connection relation table of keywords,

ah, don't have the same ID.

CodePudding user response:

refer to the second floor qq11002608 response:

Quote: refer to 1st floor captain can't program reply:

you on what you should not pick up their common column directly like the

is that there is no common column ah what can we do

No grammar you downstairs

CodePudding user response:

reference 4 floor qq11002608 response:

Quote: reference morliz son hin reply: 3/f

select a. *, b. *
From a
Left the join b on Anderson, d=b.i d

Where Anderson d like (' % XXXX % ')

This condition can't put inside connection relation table of keywords,

ah, don't have the same ID,

Relationship between the A and B table, is how A relationship, the data sources, we have A look,