Instead of two arrays, use a direct DBMS call along the lines of:
Select d1.drug from drugs d1
Where not exists
(select '*' from druginfo d2
Where d1.drugid=d2.drugid)
This will return all the entries in the table drugs that do not have
an entry in the druginfo table.
Note, this is the Oracle version, but similar functions exist for
other dbs.
Sent from my iPhone
On Jul 7, 2007, at 9:40 AM, Dan Stein <[EMAIL PROTECTED]> wrote:
I have two arrays
One is all the generic drug names in the drug data table
The other is all the generic names with the categories and sub
categories in
the drug cat subcat table
I want to be able to pull back a list of all the drugs in the drug
data
table that have not been assigned any category in the drug sub cat
able
So I do a search on both tables
I then have two arrays drugs and drugcats
I am having trouble figuring out how to bring back an array of all the
values in the 1st array that are not in the second
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 215-799-0192 ( Call 1st)
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com
"The love of one's country is a splendid thing. But why should love
stop at
the border? "
Pablo Casals
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
