I have two tables.
The 1st table has 3 records like the following.

first (table name)

first_name (column name)

Jane
Tom
Mary

And the 2nd table has 2 records like the following.

last (table name)

last_name (column name)

Tailor
Smith

I like to get my target result below by a query.

Jane Tailor
Jane Smith
Tom Tailor
Tom Smith
Mary Tailor
Mary Smith

How can I get my target result above by a query?

Hello,
If you are using SQL Server, Cross Join will solve your problem

Here is a sample

 
select first_name + ' ' + last_name
from [first], [last]
order by first_name, last_name desc

Thank you very much, eralper.