Hello,
I have joined the Master & Detail tables so that columns from both tables appear in the list view as follows:
SELECT
`master`.`id`,
`master`.`Company Name`,
`master`.`date`,
`ticker`.`id`,
`ticker`.`name`,
`ticker`.`ticker`,
`ticker`.`type`
FROM
`master` ,
`ticker`
WHERE
`master`.`id` = `ticker`.`id
I want to do a query from the Advanced Search page using selections from both tables like:
Select "date" range (from master table) and "ticker" from the ticker table
Can this be done?
Thanks!
wengen - (a very happy PHPRunner customer)
