Hai friends,

I am need a help regarding Advanced recordset in dreamweaver

I am having a database with 2 tables STAFF and USERS with common fields id, username, password, name, email and phone

Now my problem is i want to display the data present in fields of name in both the tables of STAFF and USERS
When i create a Advanced recordset two columns Name and Name are creating but displaying only 1table's data

Thank you

Sikander

Your advance query should look more or less like below for it to display all the records from both tables.

SELECT tbl1.id, tbl1.username, tbl1.password, tbl1.name, tbl1.email, tbl1.phone, tbl2.id, tbl2.username, tbl2.password, tbl2.name, tbl2.email, tbl2.phone
FROM tbl1, tbl2

Hope it helps,

Javier

Javier
"I'm a slow learner and I forget fast" grandpa
DW | FW | ASP | HTML | CSS