Hello all, I've been using sql and mysql in particular for several
years now, but I'm having some trouble coming up with a query that
will pull the data that I need from a mysql table without using
multiple queries. Here's what I'm attempting to do:
Table1
column1-a, column2-a, column3-b, column4-b, column5-c, column6-c
in this example, each the table is storing 2 values for one record,
and this had to be done in one table, at the time. I could
re-structure the database, but if there exists a query to fit my needs
I would rather do that.
I need to search the first column in each pair and if it has a
matching value to what I'm searching for pull the second column in the
pair so I can generater a report from that data. I hope this is
enough information for anyone who wishes to make a recommendation. Is
it possible to accomplish this on one query?
Thanks