I can't run this on my sql neither on my program and I would like to know if u can make a better sql .

Question

Select
A.a,
A.b,
A.c,A.tel1,A.tel2,A.tel3,A.tel4,A.tel5,A.tel6,B.tel7
From
Table A as A
Left Join Table B as B
On A.code = B .code
Where (A.pno=111111 or B.pno =111111 ) AND(tel1=12345678 or tel2 = 12345678 or tel3 = 12345678 or tel4=12345678 or tel5=12345678 or tel6=12345678 or tel7=12345678)

Answer 1

Can you describe the tables' structures? field types information is necessary to fix a query draft ...