SELECT * FROM MYTABLE WHERE ID = (given 'name', find row in XREF table matching name, get corresponding id from that row)and the XREF table is something like:
Name Id ---- -- David 1 Susan 2 Charlene 3and MYTABLE is something like:
Id Stuff -- ----- 1 xxx 1 yyy 1 zzz 2 aaa 2 bbb 3 cccI'm given a name, such as 'David', and I want to select the rows in MYTABLE with Id=1.
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.