Pulling from Multiple tables in a database

Welcome, Guest
Please Login or Register. Lost Password?

(1 viewing) (1) Guest

This is the optional Forum header for the Suggestion Box.

Page: 1

TOPIC: Pulling from Multiple tables in a database

Forum Tools

#646

Pulling from Multiple tables in a database 1 Month, 3 Weeks ago	Karma: 0
Hi All, I would like to know how retrieve data from multiple tables into one grid for display ???? I Need to get data from the following tables eg. jos_mailinglist_user and jos_mailinglist_cfields - i need data from both these jos tables to display in just one grid. Thanks Much appreciated

zunaidfloris

Fresh Boarder

Posts: 1

The administrator has disabled public write access.

#651

Re:Pulling from Multiple tables in a database 1 Month, 3 Weeks ago	Karma: 1
Hi, you can create SQL view (using e.g. phpMyAdmin), join two or more tables and display view with Table JX. Best regards, Viljem

viljem

Admin

Posts: 152

The administrator has disabled public write access.

#675

Re:Pulling from Multiple tables in a database 1 Month, 1 Week ago	Karma: 0
How can this be done... please an example

shinigami

Fresh Boarder

Posts: 4

The administrator has disabled public write access.

#679

Re:Pulling from Multiple tables in a database 1 Month ago Karma: 1

Hi,

example below that will join two tables and create DB view:
(using phpMyAdmin, running SQL script)

Code:

CREATE VIEW Something AS

SELECT t1.Name, t2.TelephoneNumber

FROM Table1 t1, Table2 t2

WHERE t1.ID = t2.ID

*You have several possibilities how to join tables (left join, right join, full join, inner join )

Best regards,
Viljem

viljem

Admin

Posts: 152

The administrator has disabled public write access.

Page: 1