I have a relational database, where cells in 1 table reference cells in another table through the use of IDs. I want to display some of this data in xGrid, but I don’t want to show IDs, I want to show the values of the cells that the IDs are referencing. How can I achieve this in 1 xGrid table?
Table “apples” has 3 columns: appleID, appleName, appleBrandID
1, apple1, 1
2, apple2, 1
3, apple3, 2
4, apple4, 2
Table “brands” has 2 colums: brandID, brandName
What I want to show in xGrid is 2 columns: appleName, brandName (of that apple)
The only way I know of doing this is to run 1 query to select all appleName & appleBrandID and then for each appleBrandID run a query and fetch the brandName.
Any ideas how I can get there?
Is there a clever SQL query that lets me combine all my queries into 1?
If not, can I replace the appleBrandIDs with BrandNames before the data is sent to xGrid?
If not, can I display the results of multiple queries in 1 xGrid table?