troubleshooting Question

SQL and Java question.

Avatar of g118481
g118481 asked on
JSPJava EESQL
7 Comments1 Solution197 ViewsLast Modified:
I need help with how to do this.
I have a table with colums, and one column has system names delimited by a comma.

My challenge is to query each record in this table (the table is very small).
Each record in the table has an ID number, name, and system fields.
The system field can have many entries, delimited by commas.
But I also need to query another table that also has a system field, and I need to match these two table's system fields up and display those records that match, based upon the system field.

Can this be done in one query?

Does this sound like a strange request?
Can someone help with a working example?

Cheers
ASKER CERTIFIED SOLUTION
Muhammad Khan
Manager, IT

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”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.

-Mike Kapnisakis, Warner Bros