Create UNIQUE view from multiple tables where fields are ignored working on Mysql


+1 vote
asked Mar 16, 2016 by Fgb9101 (360 points)
Thank you in advance. I would like to create view like:CREATE OR REPLACE VIEW all_cities AS SELECT city,date_added FROM tableA UNION DISTINCT SELECT city,date_added FROM tableB UNION DISTINCT SELECT.

3 Answers

0 votes
answered Jun 2, 2016 by JunAn (440 points)
 
Best answer
Delete support library from your main project
–1 vote
answered Apr 11, 2016 by frdDeon (440 points)
I have found an answer to this question
For details have a look at PostgreSQL: Documentation: 9.1: CREATE INDEX
+1 vote
answered Apr 14, 2016 by morken (260 points)
Hopefully this helps someone else
commented Apr 16, 2016 by SidellAccept (690 points)
I encountered this problem after removing some projects from the solution

Related questions

0 votes
4 answers
0 votes
4 answers
+1 vote
4 answers
0 votes
4 answers

What is Geekub?

Q&A site for professional and enthusiast programmers, software developers and other technical users. With your help, we hope to work together to build a library of detailed answers to just about any question that is related to programming!







...