2. PHPRunner General questions
  3. dropdown from 2 tables
This topic is locked

dropdown from 2 tables

 		7/4/2006 6:01:24 AM
PHPRunner General questions
A
 amplus author

I have 2 tables. in table 1 there is a field wagen_id and the discription of it is in table 2.

i want to see the key field from table 1 and the discription from table 2
Alexey admin 7/4/2006

Hi,
PHPRunner can not use complex SQL queries in dropdown lists.
However you can create a database view combining data from two tables.

I.e. something like this:

create view MyView as

select a.code, b.description from Table1 a left join Table2 b on a.id=b.id



Then use this view as a lookup table in PHPRunner.
Please note that Views don't work in MySQL before version 5.