Member Avatar for liro0917

I am using MY SQL when I pulled the informaiton before adding the CUSTOMER_2.dea_license which comes from the other table Customer_2 table everything pulled ok now when I tried to join the other table I get this error

Error: A syntax error has occurred. (State:37000, Native Code: FFFFFF37)

What is wrong?

SELECT
CUSTOMER.cust_num,
CUSTOMER.org_code,
CUSTOMER.cust_name,
case when CUSTOMER.stat='P' then 'AC'else 'IA' end status,
CUSTOMER.address1,
CUSTOMER.address2,
CUSTOMER.city,
CUSTOMER.province,
CUSTOMER.postal_code as zip,
CUSTOMER.phone,
CUSTOMER.fax,
CUSTOMER_2.dea_license
 FROM CUSTOMER
        INNER JOIN ON CUSTOMER.CUST_NUM=CUSTOMER_2.CUST_NUM
Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
  • 2 Contributors
  • 1 Reply
  • 125 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

Inner join customer_2 on customer.cust_num=customer_2.cust_num

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.