ExecuteSQL two tables

[Daniel C]

Hi,

I have the following ExecuteSQL statement which selects the highest document number from the control table based on a given type. The statement is:

 

ExecuteSQL ( "SELECT Max(DocNum) FROM Control WHERE Type=?";"";"";Control::Type)

 

This works fine. I have a second table called "Obsolete" that has the same field "DocNum". I would like to get the the Max of DocNum from both tables. I tried just adding Obsolete to the the FROM statement but that did not work. I am new to SQL, any help is greatly appreciated. Thanks.

 

Daniel

[Wim Decorte]

The absolute easiest would be to do two separate SQL queries, one for each table