Help with getting data from two joined tables

[Novaember]

Hi
I'm having a brain spasm today!

I have 2 tables
Table 1: QualityReviewData
Has field OpDefCust1

Table 2: OperationalDefinitionsCustomer
Has fields Checkpoint and Description

Table 1 field OpDefCust1 is joined to table 2

I want to select from QualityReviewData field OpDefCust1 and return the Description from table 2 where OpDefCust1 = Checkpoint

How do I write this in the builder screen? or in SQL if I have to. I just can't figure it out today. I know it is something simple (I need a vacation)

Thanks in advance
~Nova

 

[Novaember]

duh nevermind!
lol amazing what lunch and a short walk will accomplish!
CRISIS AVERTED! lol