Search found 2 matches

by Moos
Thu Jul 21, 2016 2:42 pm
Forum: PATSTAT Product Line
Topic: Help with SQL query - Multi-part identifier
Replies: 3
Views: 3756

Re: Help with SQL query - Multi-part identifier

Dear Mr. Kracker, Thank you very much for your help! I've learned a lot from your additional notes. You have intepreted my oversized query correctly regarding to the "patent portfolio without duplicates" / having only one application for each DOCDB family. Furthermore, your query suggestio...
by Moos
Wed Jul 13, 2016 10:40 am
Forum: PATSTAT Product Line
Topic: Help with SQL query - Multi-part identifier
Replies: 3
Views: 3756

Help with SQL query - Multi-part identifier

Dear community, I'm working on a PATSTAT Online (Autumn 2015) patent query since several weeks. My aim is to download the entire patent portfolio without duplicats of specialized companys (in this case 'Tesla Motors'). My current query (see at the end) is bulit on seven sub-queries targeting my desi...