Data Share Usage Example Q1: How do I select a sample of 200 drugs approved in the dataset? select top 200 ob.* , pat.*, ex.* ,app.institutionid ,qc.companyId, qc.companyName from fdaObProduct ob left join fdaOBPatent pat on pat.newDrugApptype = ob.newDrugAppType
Data Share Usage Example SQL1 Last Tested: January 1, 1970