Sql query help

supriya783

Hi frnds,
i am having two tables.

vendordetais(table1 name) with fields
vid
1
2
name
abc
xyz

cuisins(table2 name)

vid

1
1
2
2

cuisins

chines
thai
italian
indian

and i want the resultant table as follows

name

abc
xyz

cuisins

chinese,thai
italian,indian

can anybody help me regarding this

chandu031

Quote:

Originally Posted by supriya783

Hi frnds,
i am having two tables.

vendordetais(table1 name) with fields
vid
1
2
name
abc
xyz

cuisins(table2 name)

vid

1
1
2
2

cuisins

chines
thai
italian
indian

and i want the resultant table as follows

name

abc
xyz

cuisins

chinese,thai
italian,indian

can anybody help me regarding this

Hi,

The query is a pretty straight forward join on the two tables unless
you want the result to be a comma seperated?

Like this:

abc chinese,thai
xyz italian,indian

Cheers!!

Sql query help

re: Sql query help

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about