New line in query?

[johandenver]

I have a query that looks like this in SQL-mode:
SELECT OOB1.Firstname, OOB1.Middlename, OOB1.Lastname, OOB1.OOB1, Chr$(13) AS Expr1, OOB2.Firstname, OOB2.Middlename, OOB2.Lastname, OOB2.OOB2
FROM OOB1 INNER JOIN OOB2 ON (OOB1.[Full Unitname] = OOB2.[Full Unitname]) AND (OOB1.Firstname = OOB2.Firstname) AND (OOB1.Middlename = OOB2.Middlename) AND (OOB1.Lastname = OOB2.Lastname);

Is there a way to split the results of a query into two lines?
Can I insert a carriage return in the SQL-statement?

 

[johandenver]

Never mind, I got the result I wanted by making a union query instead.