Gettting Value From Multiple Tables

Lon Empeno

• 8. April 2022 17:11

Hello,

I have this SQL database and I have three tables: brining (variety_name, grower_name), variety (variety_name), and grower (grower_name). The brining table has 2 lookup fields from the variety and grower tables. Is there a way I can get the real value or name of the fields variety_name and grower_name instead of an assigned integer value? What I would like to get is the true value of variety_name and grower_name when I print the record. 

0

• 

  Xabier Clemente

  Moderator

  ★ BarTender Hero ★

  • 19. April 2022 09:42

  Hi Lon,
  
  Thank you for reaching us via the BarTender Community Forum!
  
  Getting a set of values from multiple tables on your database can be done by using the join function on them. We have some documentation on the subject that we believe should prove of use to you:
  
  Using Multiple Databases or Tables
  
  About Database Joins

  Please, review our support articles and feel free to reach us again if you have further queries on this subject.
  
  Thank you!

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.