Gettting Value From Multiple Tables Follow

0

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. 

1 comments

0
Avatar
Xabier Clemente
Moderator
Comment actions Permalink

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!

Please sign in to leave a comment.