Pulling the data from two tables?

[iridion_us]

Hi i already experienced this before the problem is i can't recall the right function to use to pull data from MySQL.

Let say i have two tables
TABLE 1= cclp_players
TABLE 2= cclp_players_stats

Now i'm going to use cclp_players to pull data from cclp_players_stats.
Could you help me recall the right function to use for this please.

An example is very appreciated.

Thank you very much in advance.

[Habtom]

This is more of SQL/Database question, but you can do the following to relate two tables:

SELECT A.field1, B.field2 FROM table1 A, table2 B WHERE A.fid = B.fid2

JOIN can come handy on this situation as well.

Habtom