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: 248 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 6 2018, 01:42 PM
Post
#2
|
Programming Fanatic Group: Members Posts: 1,984 Joined: 27-April 13 From: Edinburg, Texas Member No.: 19,088 |
You need to look in to INNER JOIN or OUTER JOIN to link the tables. You don't provide enough detail for me to suggest anything else.
|
tudsy |
Aug 6 2018, 01:57 PM
Post
#3
|
Advanced Member Group: Members Posts: 248 Joined: 30-September 14 Member No.: 21,611 |
You need to look in to INNER JOIN or OUTER JOIN to link the tables. You don't provide enough detail for me to suggest anything else. Hi Thanks for that. More detail. Here are the tables with the column names: CustomersArt(Itemid,email,Graphic,name,Price,terms,Age,Date); Customers(Itemid,email,name,Price,terms,Age,Date,Softbought); emailcomm(Itemid,Age,name,email,Date); subscribers(itemid,username,email,ConfirmationCode,Confirmation,Date); Thanks. |
Lo-Fi Version | Time is now: 26th September 2024 - 03:55 PM |