mysql - Creating a view with multiple tables? -
i trying create view 5 tables having issues when trying join last 2 tables together. here current mysql query: create view s_view select ac.id, a.id account_id, a.name, a.description, a.industry, a.phone_fax, a.phone_office, a.shipping_address_street, a.shipping_address_city, a.shipping_address_state, a.shipping_address_postalcode, a.shipping_address_country, c.id contact_id, c.first_name, c.last_name, c.title, c.department, c.phone_home, c.phone_mobile, c.phone_work, c.primary_address_street, c.primary_address_city, c.primary_address_state, c.primary_address_postalcode, c.primary_address_country, ea.email_address accounts inner join accounts_contacts ac on a.id = ac.account_id inner join contacts c on c.id = ac.contact_id inner join email_addr_bean_rel er on er.bean_id = a.id inner join email_addresses ea on er.email_address_id = ea.id and tables set in following way: accounts (id, first_name, last_name, etc.) contacts (id, name, etc.) ac...