-
Want desired result
I two tables, first one has 2 columns id and name and second one has 2 columns, first column is ID and second one is the comma saprated ids of first table
First Table
ID Name
1 A
2 B
3 c
4 d
Second Table
ID IDs
1 1,2
2 3,4
Now want to write an query which will return me the result like this from second table.
ID IDs
1 1
1 2
2 3
2 4
Please help. Thaks in advanced.
-
You have to write a function or stored procedure to do something like this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|