Displaying records from multiple table

[Bashar Ayyash]

Hi Guys,

I need your help to display records from multiple tables (tbl_users, tbl_dependants), I want to display user information in one row and user dependants in a column after ending user information, the two tables are related with (user_id). When the first user recordSet finishs displaying all user information + his dependants, it goes to the next line and print another user details,,, and so on.

I searched the entire forum for a help but I couldn't find.

Best Regards,
[ January 05, 2006: Message edited by: Bear Bibeault ]

[Ben Souther]

What part are you having trouble with, the SQL, parsing the results?
What have you got so far?

There are a lot of ways to get from the database to the browser.

[Bashar Ayyash]

I got so far, one row of user details + his dependants and a second row of another user details but without his dependants.

there is a little thing I must do but I couldn't figure it.

thanx for the help,

[Matt Gatten]

Your SQL statement could be written like this:

SELECT 
        TABLE1_NAME.COLUMN1, TABLE1_NAME.COLUMN2, TABLE2_NAME.COLUMN1
      FROM 
        TABLE1_NAME
      INNER JOIN
        TABLE2_NAME 
      ON
        TABLE1_NAME.RECORDID = TABLE2_NAME.RECORDID
      WHERE TABLE1_NAME.COLUMN NAME = 'xxxxxx'; 
 
      // Depending no what you want returned the where is optional.  
     

Hope that helps. They are called joins and you should read up on them.

You could also query all the names from the 1st table, loop through them and on each loop query for the dependents associated with that users name. That's not a very efficient way to do it, however.
[ January 05, 2006: Message edited by: Matt Gatten ]