Retrieving Maximum Value from 2 Tables

[blinks]

As the title says I want to retrieve the highest value from 2 tables where C1 = 'Bob'. Based on the mock-up tables below it should grab 50 from Table 2.

 

Table 1

C1C2

Bob48

Will62

 

Table 2

C1C2

Bob50

Will59

[blinks]

Sorry, I should have said - I'd appreciate help with creating an SQL query to retrieve the highest value for Bob, whether it be in Table 1 or Table 2.

 

The queries I create keep coming back as "undefined".

 

TIA

[kickstart]

Hi

 

Something like this should do it

 

SELECT MAX(C2)
FROM
(SELECT C2
FROM Table1
WHERE C1 = 'Bob'
UNION
SELECT C2
FROM Table2
WHERE C1 = 'Bob') AliasName

 

All the best

 

Keith

[blinks]

Thanks Keith; that works beautifully when I run the SQL alone. Packaged up with some PHP, it is coming back as undefined, so I guess the problem must be with my PHP.

 

Thanks heaps for your help!

[kickstart]

Hi

 

Post the php code and we can have a look to see if there is a problem there.

 

All the best

 

Keith