Im looking for solution to make query.
This is example table.
I wanna to select links and connect it in result where is the same token:
For example first result:
Could you show me good way, give little advice??
thanks for response
A very crude sql statement which may WORK *ONLY* in this case and *ONLY* for this particular data could be something like this
SELECT t1.token, t1.link, t2.link
FROM exampletable AS t1 , exampletable AS t2 WHERE t1.link <> t2.link AND t1.token = t2.token group by t1.token
You could use a cursor to loop through your first table to select the deisred recordsets.
What platform? In MySQL there is group_concat
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)