Sql query help

[supriya783]

Hi frnds,
i am having two tables.

vendordetais(ta ble1 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]

Hi frnds,
i am having two tables.

vendordetais(ta ble1 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!!