Creating a view from multiple tables |
Creating a view from multiple tables |
tudsy |
Aug 5 2018, 11:32 PM
Post
#1
|
Advanced Member Group: Members Posts: 246 Joined: 30-September 14 Member No.: 21,611 |
Hi
I have 4 tables, CustomersArt,Customers,subscribers and emailcomm. My question is, how do i create a view from these 4 tables with the column email ? I have done a view from one table (see below): $query = "CREATE VIEW ecovib2d AS SELECT email FROM CustomersArt"; Any help will be appreciated. |
CharlesEF |
Aug 16 2018, 12:13 AM
Post
#2
|
Programming Fanatic Group: Members Posts: 1,981 Joined: 27-April 13 From: Edinburg, Texas Member No.: 19,088 |
I don't see anything wrong, as far as syntax. But, I've never heard of 'FULLJOIN'. I've heard of 'FULL OUTER JOIN' and 'FULL INNER JOIN'. Maybe it should be 'FULL JOIN'?
|
tudsy |
Aug 20 2018, 08:11 PM
Post
#3
|
Advanced Member Group: Members Posts: 246 Joined: 30-September 14 Member No.: 21,611 |
I don't see anything wrong, as far as syntax. But, I've never heard of 'FULLJOIN'. I've heard of 'FULL OUTER JOIN' and 'FULL INNER JOIN'. Maybe it should be 'FULL JOIN'? Hi Thanks for that. I put commas at the end of each join and iot got rid of that error. However, I get this error now: Error Message: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'FULL' I have attached the rest of the code. view1.php ( 1.3k ) Number of downloads: 1594 view.php ( 1.9k ) Number of downloads: 1587 |
Lo-Fi Version | Time is now: 1st June 2024 - 12:20 AM |