Two SQL statments in one Query

[Tajaldeen]

Hi guys, I put this statement in a Query SQl to retrieve the first item of a Table named Students.

SELECT Min(Name) AS FirstName
FROM Students

And I put this one in another query SQL to retrieve the first item of a Query named Substudents

SELECT Min(Name) AS LastName
FROM Substudents;

My question is:
How can I put the two statements in one Query to show the results in the same Query table.
Thank you very much

[Welshgasman]

Use a Union query.
Names will need to be the same though?, so perhaps add another field to identify which table it came from?

Otherwise join the tables and take each field from each table, if you want LastName, FirstName per record.

[moke123]

I believe using Min() on text will return an alphabetical result, not necessarily the "First" record.

What is your ultimate goal?

[Welshgasman]

I believe using Min() on text will return an alphabetical result, not necessarily the "First" record.

What is your ultimate goal?

Fair point, you could/would get LastName for 1 student and the FirstName for another completely different student?

[NoellaG]

Maybe explain what you are trying to do, and what's the structure of table students? What is the SQL of query Substudents, what table is it based on?

If you want unique names and query substudents is based on the same table Students:

select distinct Name, FirstName from Students

might do the trick

[madpiet]

My question is:
How can I put the two statements in one Query to show the results in the same Query table.
Thank you very much

SELECT TOP 1 FirstName, lastname
FROM MyTable
ORDER BY FirstName, LastName

will return the first record in the table as determined by the sort order (Firstname, lastname).