Gettting Value From Multiple Tables

Lon Empeno

• 2022年04月08日 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

  版主

  ★ BarTender Hero ★

  • 2022年04月19日 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

请先登录再写评论。