ryanjsells
-
Posts
1 -
Joined
-
Last visited
ryanjsells's Achievements
Newbie (1/5)
0
Reputation
-
I am trying to use the Union statement in a sql statement in MySQL and it's not working. When using the Union statement it is NOT supposed to return duplicate entries from the 2 tables, but for some reason mine is. Is there a setting I am missing? SELECT CUST_NUM, CUST_LNAME, CUST_FNAME FROM customer UNION SELECT CUST_NUM, CUST_LNAME, CUST_FNAME FROM customer_2;