Pulling from Multiple tables in a database

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

Hi,

you can create SQL view (using e.g. phpMyAdmin), join two or more tables and display view with Table JX.

Best regards,
Viljem

How can this be done... please an example

Hi,

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

CREATE VIEW Something AS
SELECT t1.Name, t2.TelephoneNumber
FROM Table1 t1, Table2 t2
WHERE t1.ID = t2.ID

Hi

A new user, can't find how to create a post so adding my question to this. You have a nice product! I need some guidance as to the best way to do this (see below). I am an experienced SQL and db guy so can create view etc - the issue I have is I need dynamic sql in the manner of

select from foo where name like 'FRED%' where FRED is what the user keyed in the search or other box. As it is now the user can put FRED in the search box or just a wildcard (%) and get ALL the rows of the database.
Ideally I'd like to be able to change the where clause that populated the table dynamically.

I'm thinking if I had another textbox someplace and the user entered FRED into it (for example) I could update a table called prefix_USERVAL with username and FRED (in this case) and then change the query to match on username and look at this new table to figure out the search extent BEFORE the grid os populated.

Is any of this making sense?

Thanks

Chris