Skip to Content
0
Former Member
May 14, 2008 at 07:59 AM

join

26 Views

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'