To join table in a single query follow the example below.
[codesyntax lang=”sql”]
select * from lk1, lk2 where lk2.idlk1 = lk1.idlk1 order by lk1.cat, lk2.lkn
[/codesyntax]
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.