Joining DB tables using the SQL Yoga Library
Posted: Fri Oct 11, 2013 2:12 pm
[This post is an archive from the old SQL Yoga forums]
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 -
I am not sure how to accomplish the above join and retrieve the data for display using the SQL Yoga library.
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%'