SQL query

Question

i have two database table from one table i am selecting all fields to be displayed on a form. From another database i'm trying to display just one field. Both database use delegation to relate to each other. Instead of writting another sql query out i was hoping will it be possible to merge the present query and retrive the data from the seceond query. this is how the first one is done: String sQuery = SELECT * FROM License WHERE Name = '+ label1.Text +' AND LicenseGroupID = '+ label2.Text +'; now i'm trying to retrive the LicenseGroup Name from the table LicenseGroup. I dont want to write another query out. as you can see LicenseGroupID is used on both table to match fields to each other. Is there any way i could use a combination factor tin the script to retrive the name from licengroup table. Thanks Mac

spgilmore · Answer

You can probably use a join. This depends on your database. Most databases support joins like this: 'select license.* licensegroup.LicenseGroupID from license licensegroup where license.licensegroupid = licensegroup.licensegroupid and license.name=' + label1.text + ' and license.licensegroupid='+label2.text -OR- 'select L.* G.LicenseGroupID from license as L inner join licensegroup as G on L.licensegroupid = G.licensegroupid and L.name=' + label1.text + ' and L.licensegroupid='+label2.text