Member Avatar for Noliving
Noliving 0 Junior Poster in Training

Select order_num, order_date, customer_name, description
From orders,part,customer
Union
Select order_num, order_date, customer_name, description
From orders,part,customer
Where customer_name = 'Johnson's Department Store' or description = 'Gas Range';

I'm getting this error and from my understanding it looks like it should be fine:

SQL command not properly ended

  • 1 Contributor
  • 0 Replies
  • 53 Views
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.