Gettting Value From Multiple Tables 关注



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. 

1 评论

Xabier Clemente
评论操作 固定链接

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!