SELECT LastName, FirstName, Address, City, State, Zip
FROM Clients
UNION
SELECT LastName, FirstName, Address, City, State, Zip
FROM Patrons
ORDER BY LastName, FirstName;
Thanks for fast respond, i have no experience with databases on android , so i'm looking for someone who can convert this queries to b4a code, and i will modify the code on my own.
Dim MyQuery As String
MyQuery = "Select LastName, FirstName, Address, City, State, Zip FROM Clients " _
" UNION Select LastName, FirstName, Address, City, " _
& "State, Zip FROM Patrons ORDER BY LastName, FirstName"
Cursor1=SQL1.ExecQuery(MyQuery)
Dim MyQuery As String
MyQuery = "Select LastName, FirstName, Address, City, State, Zip FROM Clients " _
" UNION Select LastName, FirstName, Address, City, " _
& "State, Zip FROM Patrons ORDER BY LastName, FirstName"
Cursor1=SQL1.ExecQuery(MyQuery)