Filtered Join

Discuss MySQL Ajax Table Editor Paid Version

Filtered Join

Postby makistar » Wed Aug 27, 2014 1:05 pm

I like to join two tables. But in the dropdown should be only entries visible with a specific value in the second table.

Example:

Table one
Log List with servername (joined from table two), date, logtext

Table two
List of servers with servername, end of lifetime flag, ...

in the log table join pull down should only the servers without end of lifetime be visible
makistar
 
Posts: 32
Joined: Mon Jan 07, 2013 10:48 am

Re: Filtered Join

Postby admin » Thu Aug 28, 2014 2:34 am

Take a look at the select_query option.
admin
Site Admin
 
Posts: 1502
Joined: Fri Jul 11, 2008 1:34 am


Return to Paid Version

Who is online

Users browsing this forum: No registered users and 6 guests

cron