Urgent 001
-
I need some instruction and help Customer Table CustID CustName 01 ABC 02 ACB 03 ADB Order Table OrderID CustID 1001 01 1002 01 1003 01 1004 02 1005 02 1006 03 1007 03 1008 03 1009 03 1010 03 I want those output like below CustID CustName OrderID 01 ABC 1001, 1002, 1003 02 ACB 1004, 1005 03 ADB 1006, 1007, 1008, 1009, 1010 Please help me. Thanks Sarfaraj
Sarfarj Ahmed
-
I need some instruction and help Customer Table CustID CustName 01 ABC 02 ACB 03 ADB Order Table OrderID CustID 1001 01 1002 01 1003 01 1004 02 1005 02 1006 03 1007 03 1008 03 1009 03 1010 03 I want those output like below CustID CustName OrderID 01 ABC 1001, 1002, 1003 02 ACB 1004, 1005 03 ADB 1006, 1007, 1008, 1009, 1010 Please help me. Thanks Sarfaraj
Sarfarj Ahmed
I think you cannot do it in single SQL query..... populate a dataset with following query..
SELECT Customer.CustID, CustName, OrderID FROM Customer INNER JOIN Orders ON Customer.CustID=Orders.CustIDthen loop through your dataset to make customized dataset or datatable which you want ....where you can concatenate the OrderID fields.... did u get me???Tirtha "A man can ride on your back only when it is bent....."
-
I need some instruction and help Customer Table CustID CustName 01 ABC 02 ACB 03 ADB Order Table OrderID CustID 1001 01 1002 01 1003 01 1004 02 1005 02 1006 03 1007 03 1008 03 1009 03 1010 03 I want those output like below CustID CustName OrderID 01 ABC 1001, 1002, 1003 02 ACB 1004, 1005 03 ADB 1006, 1007, 1008, 1009, 1010 Please help me. Thanks Sarfaraj
Sarfarj Ahmed
Sarfaraj Ahmed wrote:
Urgent 001
This is a useless subject line. Please use more appropriate subject lines in future. Hint: No appropriate subject line will include the word "urgent"
-
I think you cannot do it in single SQL query..... populate a dataset with following query..
SELECT Customer.CustID, CustName, OrderID FROM Customer INNER JOIN Orders ON Customer.CustID=Orders.CustIDthen loop through your dataset to make customized dataset or datatable which you want ....where you can concatenate the OrderID fields.... did u get me???Tirtha "A man can ride on your back only when it is bent....."
How can I make a customized dataset or dataTable and how can I concatenate the OrderID fields. please send me more instructions with some code Waiting for ur reply.......
Sarfarj Ahmed