SQL statement to return multiple values of a field to multiple fields

Do you assign this value in SQL, or in delphi or c.

4 rows become 1 row?

If you're using SQL Server, you can do it in a weird way:

select

distinct ',sale_item

from sale_report

for xml path(''

The landlord can test it and finally use a for xml path(''That's it.

The result of my SQL execution above is:

c,a,b

This is a row column or something, you can refer to decode.

If you don't need a SQL implementation, you can use the cursor cursor to query and then summarize the result set you want. Can.

4 rows become 1 row?

If you're using SQL Server, you can do it in a weird way:

select

distinct ',' + sale_itemfrom

sale_report

for xml path('')

The landlord can test it and finally use a for xml path(''That's it.

The result of my SQL execution above is:

c,a,b

update b set x = case when >= then 'yes' else 'no' end

from a , b

where (here add the condition of the corresponding record in tables A and B, such as =, otherwise there is no condition update error.) )

This first requires a field that is uniquely associated with tables A and B, assuming the field name: idselect b* case when > then 'yes' else 'no' end as x

from b , a

where =

What is the relationship between table A and b, and are there any related fields? Or is there only one row of value per table?

That's what you mean, right? Let's say "another table" is a and the field to be inserted is, then:

update a

set a|b|c from ..where ..where a...

Don't understand what you mean?

If you combine multiple fields in a record into one value, set up a tablea field a, b, and c; Table tableb, field dtablea

a b ci hate you

I want to insert a tableb table like this.

tableb：

di hate you

That's it: insert into tableb(d)select a||b||c from tablea

If you combine multiple records into one.

You'll have to use a stored procedure.

insert into Table 1 (Field) select [field a] from [Table 2] where [id] = 1 union select [field b] from [Table 2] where [id] = 1 union select [field c] from [Table 2] where [id] = 1

Use id to make an internal connection between the two tables, and use cast() to convert int to varchar().

select ,from table1 t1 inner join table2 t2

on cast( as varchar(8))=;

if object_id('table1') is not null

begindrop table table1

endgocreate table table1 (a int ,b int)goinsert into table1

select 1,1

unionselect 1,2

unionselect 1,3

unionselect 2,1

goselect a.* from table1 a where exists(select * from table1 b where and <>

- Remember to adopt it in time, the task is not completed today, and there is only one left.

Onlookers, it's actually very simple.

The first thing you need to do is determine which field it is.

For example, the values in field A and field B are all abc

select * from the table name.

where field a='abc'and field b='abc'