0
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 .
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)
1 Réponse
+ 4
Can you describe the tables' structures? field types information is necessary to fix a query draft ...