Hi Trevor:
I am new to databases and I have been using the SQL Yoga library (love it). So far it's been great.
I am trying to join two tables and have run into an impasse as to how to accomplish the join using the SQL library.
The two table names are CYTO2010Data and AP2010Data
I am using the Valentina DB with a Runtime Rev front end.
In Valentina the SQL join is accomplished by -
Code: Select all
Select CYTO2010Data.Accession,CYTO2010Data.PathologistDX,AP2010Data.Accession,AP2010Data.Code from CYTO2010Data, AP2010Data where CYTO2010Data.MRN= AP2010Data.MRNM AND CYTO2010Data.PathologistDX like '%GYB HSIL%' and AP2010Data.Accession not like '% C-%' and AP2010Data.Accession not like '%CC%' and AP2010Data.Code like '%Y%'