Joins in SQL
Joins in SQL
(OP)
I have a table, which contains several fields, which can have a value of 1,2,3 or 4. I have created another table which has the entries.
1 Large
2 Medium
3 Small
4 None
I would like to construct a query which searches the first table, but instead of outputing 1,2,3 or 4, Large, Medium, Small are outputted.. how can I do this?
1 Large
2 Medium
3 Small
4 None
I would like to construct a query which searches the first table, but instead of outputing 1,2,3 or 4, Large, Medium, Small are outputted.. how can I do this?





RE: Joins in SQL
Then construct your query like this:
Select ColA, ColD
From TblA, TblB
Where TblA.ColB = TblC.ColC
For multiple columns in TblA with the same values, it becomes more difficult. To make it easy on myself, I do multiple queries, or have multiple tables but I know that is not really the most efficient use of computer memory.