johandenver
Registered User.
- Local time
- Today, 19:39
- Joined
- May 4, 2010
- Messages
- 27
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?
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?
