How to build this SQL statement?
| From: | ckieninger | Date: | Sat, 07 Jul 2001 11:47:40 +0000 |
| Subject: | How to build this SQL statement? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-56631@lists.php.net to get a copy of this message | ||
Hello,
i've to build a SQL Statement from a table with the following resultset
table with rows
id subid roleid rolebundle name
50 0 0 50.0.0 header1
50 1 0 50.1.0 subheader1
50 2 0 50.2.0 subheader2
50 3 0 50.3.0 subheader3
50 3 1 50.3.1 subheader3.1
50 3 2 50.3.2 subheader3.2
50 4 0 50.4.0 subheader4
50 4 1 50.4.1 subheader4.1
50 4 2 50.4.2 subheader4.2
9 rows
SQL statement ???
Resultset
id subid roleid rolebundle name
50 1 0 50.1.0 subheader1
50 2 0 50.2.0 subheader2
50 3 1 50.3.1 subheader3.1
50 3 2 50.3.2 subheader3.2
50 4 1 50.4.1 subheader4.1
50 4 2 50.4.2 subheader4.2
6 Rows