The following SQL retrieves two records.<BR>SELECT MAX(o_custno) custno FROM organization UNION SELECT MAX(c_custno) custno FROM company;<BR><BR>How can I select the maximum value of the query? I only want ONE record. I&#039ve tried using SELECT MAX(custno) from the above SQL, but it generates an error - probably because it doesn&#039t understand the custno value (I think).<BR><BR>Any help very much appreciated!