Man of Honour
I have a few tables that use <location1ID> and <location2ID> - these are FK's from another table, <locations> - this has columns:
ID, Port, Slot, Station, Module
For each row in this table, you'd have
ID, something, something, null, null
or
ID, null, null, something, something
What I want to do is use the somethings (their text values) rather than the numerical ID when displaying the results of a query..
how do I do that?
ID, Port, Slot, Station, Module
For each row in this table, you'd have
ID, something, something, null, null
or
ID, null, null, something, something
What I want to do is use the somethings (their text values) rather than the numerical ID when displaying the results of a query..
how do I do that?