Sorry for the crappy Subject, it's kinda hard for me
to "catch" my problem in a snappy "Subject".
I have a database containing several versions and
languages of pdfs for several products. I want to make
a "select" which delivers a table of products with only
_1_ pdf per product. It should be the "newest" version in
a selected language (or english language if the selected
is not available)
This is my (simplified) Table:
FK_Product (foreign key for the product this pdf is for)
FK_PDF (foreign key for the pdf)
Version (Version number of this pdf, the ...