Name Value1 jim 100 jak 50 stiv 25
Name value1 Jim 100 Jim 50 Jim 25 jack 100 jack 50 jack 25 stiv 100 stiv 50 stiv 25
SELECT t.name, t1.value FROM Table_1 AS t CROSS JOIN Table_1 AS t1 ORDER BY t.infoID
Select t1.name,t2.value from myTable t1, myTable t2
SELECT b.NAME, a.Value1 FROM Table_1 a, Table_1 b
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)