memorial_data icon indicating copy to clipboard operation
memorial_data copied to clipboard

How i can select data?

Open brainstorm1313 opened this issue 3 years ago • 0 comments

Hi How i can select data? I built a query: SELECT ages.AGE, books.BOOK, fnames.FNAME, lnames.LNAME, names.NAME, nations.NATION, prigovor.PRIGOVOR, stat.STAT, sudorg.SUDORG, works.AWORK, p.* FROM persons p LEFT JOIN ages ON p.AGE = ages.AGEID LEFT JOIN books ON p.BOOK = books.BOOKID LEFT JOIN fnames ON p.FNAME = fnames.FNAMEID LEFT JOIN linkbirthye ON p.PERSONID = linkbirthye.PERSONIDL LEFT JOIN lnames ON p.LNAME = lnames.LNAMEID LEFT JOIN names ON p.NAME = names.NAMEID LEFT JOIN nations ON p.NATION = nations.NATIONID LEFT JOIN prigovor ON p.PRIGOVOR = prigovor.PRIGOVORID LEFT JOIN stat ON p.STAT = stat.STATID LEFT JOIN sudorg ON p.SUDORGAN = sudorg.SUDORGID LEFT JOIN works ON p.AWORK = works.AWORKID

What are link* tables? How can I join them to this data? what is personidl column? Is it another DB?

brainstorm1313 avatar Oct 24 '21 22:10 brainstorm1313