Create UNIQUE view from multiple tables where some fields are ignored from Mysql


0 votes
asked Mar 16, 2016 by This_est (1,010 points)
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. Any ideas what could be causing this issue with linkedin

2 Answers

+2 votes
answered Mar 20, 2016 by GuvKary (1,700 points)
There are some people here that have no idea what they are talking about. Read http://www.postgresql.org/docs/9.1/static/sql-createindex.html for more details
0 votes
answered Mar 22, 2016 by Prefer5118 (230 points)
This is how I solved this problem. So modifying the decorator may be more flexible

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!







...