This topic is locked

View Content of different Tables on one List page

8/15/2007 4:16:49 AM
PHPRunner General questions
D
dieter author

I have different Tables (Printers, Monitors, PC, Software and Users).

Each of this tables has more fields eg. IP-Address, Serial-Number, Resolution. One Field is the same in all Tables, the username from table users.
What I want to see is this:

  1. A Listpage with the username, eg. IP-Address (from table PC), Resolution (from Monitors), Printername (from Printers)
  2. In the next row of Listpage, same username, other IP-Address (from table PC because he has 2 PC), nothing because he has only the above monitor (with a switch), another Printername (from Printers because he has two printers)



I prefer the above possibility but if this will not work,

perhaps it is possible as a Mastertable with Users (Username) as Master ?
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=5996&image=1&table=forumtopics' class='bbcemoticon' alt='<<' />

J
Jane 8/15/2007

Dieter,
I think you can create custom view on the Datasource tables tab and then join all your tables on the Edit SQL query tab. Use left join or right join clause.

Here are some samples:

http://webcheatsheet.com/sql/interactive_s...al/sql_join.php

http://www.w3schools.com/sql/sql_join.asp