Assigning Unique URLs

[dpgirl]

I have a table called MASTER with 10K records:

id segment
123 A
346 B
478 B
316 A

I have another table called URLS_A with 6K records. This table has only one field "URL" -- every record has a unique URL value assigned to it.

I have another table called URLS_B with 6K records. This table has only field "URL" and every record has a unique URL value assigned to it.

I need to append a unique URL value to every record in the MASTER table. The URL value should come from table URLS_A if the segment value is A. The URL should come from table URLS_B if the segment value is B. It doesn't matter what order the URLs are assigned, as long as each URL is not assigned more than once. What is the best way to do this?

 

[r937]

What is the best way to do this?

i would use application logic while processing the rows sequentially after returning them from the tables in random order

r937.com | rudy.ca