I am carrying out an inner join
on afield1 = bfield1
however I need to select afield1=bfield` = 'constant value'
always.
Do I add a where condition like
a~field1 = 'constant value'
or
b~field1= 'constant valeu'
or can i carry out a join like
ON afield1=bfield` = 'constant value'